mysql union all where clause code example

Example: union all in mysql

SELECT City FROM Customers
UNION ALL
SELECT City FROM Suppliers

 ORDER BY City;