i get result with UNION put i want know result form any table
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.