mysql union后面查不出_mysql – 多个UNION查询不起作用

您已将问题标记为MySQL,并使用方括号[].据我所知,方括号对MySQL无效,仅对Microsoft产品有效(SQL Server / MS Access).因此,如果您需要使用反引号括起表/列名称.

The identifier quote character is the backtick (“`”):

所以我认为您的查询应该是：

SELECT `Ordine numero` AS ordine, `data ordine` AS data, comm AS commessa

FROM `archivio globale`

WHERE `ordine numero` IS NOT NULL

UNION ALL

SELECT `numero ordine cliente` AS ordine, `data ordine cliente` AS data, numero AS commessa

FROM `ricambi`

WHERE `numero ordine cliente` IS NOT NULL

UNION ALL

SELECT `numero ordine cliente` AS ordine, `data ordine cliente` AS data, numero AS commessa

FROM `trasferte`

WHERE `numero ordine cliente` IS NOT NULL

ORDER BY `ordine`;

编辑,如果您使用MS Access,则需要使用方括号：

SELECT *

FROM

(

SELECT [Ordine numero] AS ordine, [data ordine] AS data, comm AS commessa

FROM [archivio globale]

WHERE [ordine numero] IS NOT NULL

UNION ALL

SELECT [numero ordine cliente] AS ordine, [data ordine cliente] AS data, numero AS commessa

FROM [ricambi]

WHERE [numero ordine cliente] IS NOT NULL

UNION ALL

SELECT [numero ordine cliente] AS ordine, [data ordine cliente] AS data, numero AS commessa

FROM [trasferte]

WHERE [numero ordine cliente] IS NOT NULL

) x

ORDER BY [ordine];