Try it Yourself: SQL Union

SQL Union

Language: SQL

SELECT city FROM customers
UNION
SELECT city FROM suppliers
ORDER BY city;

SELECT city FROM customers
UNION
SELECT city FROM suppliers
ORDER BY city;

Output

Click Run to execute this code.