Here are the results with UNION, but I also want to know the source table for each result:
SELECT City FROM Customers
SELECT City FROM Suppliers
ORDER BY City;
SELECT City,'Customers' as tblName FROM Customers UNION SELECT City,'Suppliers' as tblName FROM Suppliers ORDER BY City;
Play with the order by.
Also consider doing a UNION ALL. See this for the difference.