The following SQL statement lists all customers and suppliers:
SELECT 'Customer' AS Type, ContactName, City, Country
FROM Customers
UNION
SELECT 'Supplier', ContactName, City, Country
FROM Suppliers;
FROM Customers
UNION
SELECT 'Supplier', ContactName, City, Country
FROM Suppliers;
Practice Excercise Practice now