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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UNION QUERY 2
Union query producing duplicate records 7
Union query 5
Union Query and Field Alias 7
Comlex union query question 4
Union Queries - Record Formatting 1
union query problem 16
union query 4

Back
Top