mysql 錯誤1248_mySQL錯誤：#1248 – 每個派生表必須有自己的别名

如何通過設定别名來更正此錯誤？錯誤：#1248 – 每個派生表必須有自己的别名

SELECT

entry_id,

author_id,

title,

status

FROM exp_channel_titles

LEFT JOIN

(SELECT

entry_id,

field_id_14,

field_id_15,

field_id_25,

field_id_27,

field_id_28,

field_id_29,

field_id_30,

field_id_31,

field_id_32,

field_id_33,

field_id_34,

field_id_35

FROM exp_channel_data

WHERE entry_id = exp_channel_titles.entry_id)

LEFT JOIN

(SELECT

member_id,

email

FROM exp_members

WHERE member_id = exp_channel_titles.author_id)

WHERE title LIKE %Member%

AND status = 'complete'