mySQL错误:#1248-每个派生表必须具有自己的别名 [英] mySQL error: #1248 - Every derived table must have its own alias

问题描述

如何通过设置别名来纠正此错误? 错误:#1248-每个派生表必须具有自己的别名

How would I correct this error by setting an alias? error: #1248 - Every derived table must have its own alias

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'

推荐答案

好吧，正如错误所述，您必须命名每个派生表.例如

Well, as the error says, you have to name every derived table. For instance

(SELECT   
    member_id,
    email
FROM exp_members
WHERE member_id = exp_channel_titles.author_id)

是派生表.像这样添加一个名称:

Is a derived table. Add a name like so:

(SELECT   
    member_id,
    email
FROM exp_members
WHERE member_id = exp_channel_titles.author_id) tempTableNameGoesHere

(我认为我敢肯定在括号和名称之间不需要as，但是我想您可以尝试一下，或者从这里查找它；))

(I think I'm sure there is no need for an as between the bracket and the name, but I suppose you can try it, or look it up from here ;) )

您的后续问题(我们要花多长时间?:))

Your follow-up question (how long are we going to do this? :) )

 WHERE title LIKE %Member% 

应该是

WHERE title LIKE '%Member%'

这篇关于mySQL错误:#1248-每个派生表必须具有自己的别名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！