UNION ALL 與 WHERE

UNION ALL 從客戶和供應商表中選擇所有（重複值）德國城市。這裡 Country="Germany" 將在 where 子句中指定。

查詢：

SELECT City, Country FROM Customers
WHERE Country='Germany'
UNION ALL
SELECT City, Country FROM Suppliers
WHERE Country='Germany'
ORDER BY City;

結果：

Number of Records: 14