UNION ALL With WHERE

UNION ALL to select all(duplicate values also) German cities from the “Customers” and “Suppliers” tables. Here Country="Germany" is to be specified in the where clause.

Query:

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

Result:

Number of Records: 14