以下是 Union 的结果,但我也想知道与每行关联的源表:
SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;
查询的实际结果如下:
城市
572
123
但我想要这个结果:
城市tablet_result
572 客户
123 生产厂家
SELECT City, 'Customers' as tablet_result FROM Customers
UNION
SELECT City, 'Suppliers' as tablet_result FROM Suppliers
好的,试试:
SELECT City,'Customers' as tblName FROM Customers
UNION
SELECT City,'Suppliers' as tblName FROM Suppliers
ORDER BY City;
按顺序玩。
还要考虑做一个联合 ALL。请参阅此区别。