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';)