What is a UNION Query?
“A union query combines fields from two or more tables or queries into one field in the query’s results. You might use a union query to combine data from two tables. For example, you might combine company name and city data for all companies in Brazil that are listed in the Suppliers and Customers tables.” Access 2000/2002 Help. Note that both SELECT statements must return a dynaset that has the same number of columns with the same datatypes in corresponding columns. The UNION clause will combine the two dynasets into one dynaset. You cannot create a UNION query via the query design window, but you can create each separate SELECT query this way, then copy/paste the SQL into a new UNION query into the query SQL window.
