The UNION ALL command merges the result sets of two or more SELECT statements, including duplicate values.
The provided SQL statement retrieves the cities (including duplicate values) from both the “Customers” and the “Suppliers” table:
| SELECT City FROM Customers UNION ALL SELECT City FROM Suppliers ORDER BY City; |