UNION Operation Example

This example retrieves the names and cities of all suppliers and customers in Brazil.

SELECT CompanyName, City 
FROM Suppliers 
WHERE Country = 'Brazil'
UNION
SELECT CompanyName, City 
FROM Customers
WHERE Country = 'Brazil';)