How do I set up a union query?

  • Thread starter Thread starter Guest
  • Start date Start date
Union queries have to be created in SQL view, they can not be created using
the graphical query design grid. To create a union query, start a new query
as usual, then select SQL View from the View menu.

Here's an example that returns company names from the Customers, Shippers,
and Suppliers tables in the Northwind sample database ...

SELECT CompanyName FROM Customers
UNION SELECT CompanyName FROM Suppliers
UNION SELECT CompanyName FROM Shippers
 
Back
Top