每个派生表在MySQL中必须有自己的别名错误 [英] Every derived table must have its own alias error in MySQL

问题描述

我有以下查询：

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"
)

这给我一个错误：

＃1248-每个派生表必须有自己的别名

#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

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