聯合 ALL

UNION ALL 從客戶和供應商表中選擇所有（重複值）城市。

查詢：

SELECT City FROM Customers
UNION ALL
SELECT City FROM Suppliers
ORDER BY City;

結果：

Number of Records: 12

CityAachen
Albuquerque
Anchorage
Ann Arbor
Annecy
Barcelona
Barquisimeto
Bend
Bergamo
Berlin
Berlin
Bern