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'