mysql 衍生表必须有别名,每个派生表在MySQL中必须有自己的别名错误

I have the following query:

SELECT SUM( cost )

FROM (

SELECT s.cost

FROM sandwiches AS s

WHERE s.name = "Cheese Steak"

)

UNION (

SELECT p.cost

FROM pizza AS p

WHERE TYPE = "Plain"

AND SIZE = "L"

)

That gives me an error of:

#1248 - Every derived table must have its own alias

解决方案

You need to alias your temp tables

SELECT SUM( cost )

FROM

(

(

SELECT s.cost

FROM sandwiches AS s

WHERE s.name = "Cheese Steak"

) AS T1

UNION

(

SELECT p.cost

FROM pizza AS p

WHERE TYPE = "Plain"

AND SIZE = "L"

) AS T2

) AS T