mysql - MySQL 高级查询代码 1064 出错

Question

当我尝试执行以下查询时，我不断收到错误:

SELECT C.CustomerID WITH C.CustomerName WITH O.OrderDate WITH O.TotalOrderAmount
FROM CUSTOMERS C
LEFT JOIN [ORDERS] 0
ON C.CustomerID=O.CustomerID

UNION

SELECT C.CustomerID, C.CustomerName, O.OrderDate, O.TotalOrderAmount
FROM CUSTOMERS C
RIGHT JOIN [ORDERS] 0
On C.CustomerID-O.CustomerID;

下面是我在 MySQL 中收到的代码:

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[ORDERS] 0 ON C.CustomerID=O.CustomerID  UNION  SELECT C.CustomerID, C.CustomerN' at line 3

非常感谢您为纠正此错误提供的任何帮助。

Answer 1

只需执行完全连接而不是并集。应该在这里给你相同的结果:

SELECT C.CustomerID, C.CustomerName, O.OrderDate, O.TotalOrderAmount
FROM CUSTOMERS C
full JOIN [ORDERS] 0
On C.CustomerID-O.CustomerID