mysql - 在 1 个表中组合 2 个 SQL 查询

Question

我有 2 个查询:

查询 1:

SELECT w2.Avis,w2.Cde_Sap,w2.Don_Ordre,w2.PN_in ,w2.SN_in,w2.DATE2,w2.Statut_Cde,client.Zone
 FROM w2
 INNER JOIN client
 ON w2.Don_Ordre = client.Client 
 WHERE client.Zone='CLR' 
 SORT BY w2.Avis ;

查询 2:

SELECT w3.Avis,w3.Cde_Sap,w3.Don_Ordre,w3.PN_in , w3.SN_in,w3.DATE2,w3.Statut_Cde,client.Zone
FROM w3
INNER JOIN client
ON w3.Don_Ordre = client.Client 
WHERE client.Zone='CLR' 
SORT BY w3.Avis;

我想在 1 Page 和 SORT BY Avis 中显示这两个查询。它不工作。

Answer 1

UNION ALL，在派生表中。 ORDER BY 结果:

select * from
(
SELECT w2.Avis as Avis,w2.Cde_Sap,w2.Don_Ordre,w2.PN_in ,w2.SN_in,w2.DATE2,w2.Statut_Cde,client.Zone
 FROM w2
 INNER JOIN client
 ON w2.Don_Ordre = client.Client 
 WHERE client.Zone='CLR' 

UNION ALL

SELECT w3.Avis,w3.Cde_Sap,w3.Don_Ordre,w3.PN_in , w3.SN_in,w3.DATE2,w3.Statut_Cde,client.Zone
FROM w3
INNER JOIN client
ON w3.Don_Ordre = client.Client 
WHERE client.Zone='CLR'
) dt
order by avis

或者:

SELECT w2.Avis,w2.Cde_Sap,w2.Don_Ordre,w2.PN_in,w2.SN_in,w2.DATE2,w2.Statut_Cde,client.Zone
 FROM (select * from w2
       UNION ALL
       select * from w3) as w2
 INNER JOIN client
 ON w2.Don_Ordre = client.Client 
 WHERE client.Zone='CLR' 
 SORT BY w2.Avis ;