Union ALL

UNION ALL to select all (duplicate values also) cities from the “Customers” and “Suppliers” tables.

Query:

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

Result:

Number of Records: 12

City
-------
Aachen
Albuquerque
Anchorage
Ann Arbor
Annecy
Barcelona
Barquisimeto
Bend
Bergamo
Berlin
Berlin
Bern

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents