Combine Multiple Queries

Combine Multiple Queries

Post by Bill Sturd » Sun, 16 May 2004 02:56:14


I have table A which contains one set of records. I have
a query that pulls the records from Table A. The query
produces 100 records.

I also have table B which contains different fields than
Table A. I have a query that pulls records from Table B
and uses specific fields to create dummy records that look
just like those from Table A in format but that only have
a couple of fields filled in. The query produces 50
records.

The problem: I need to merge the records from Query
A/Table A with the manufactured records from Query B/Table
B for a total of 150 records BEFORE I export them to Excel.

How do I create a 3rd query that merges the results of
Query A and Query B. I am drawing a complete blank on
this one!
 
 
 

Combine Multiple Queries

Post by Dale Fy » Sun, 16 May 2004 03:11:48

Create a third query that unions the other two.

SELECT * FROM qryA
UNION ALL
SELECT * FROM qryB

*Note: All of the fields need to be in the same sequence
in the two queries, and the field types for the result set
of both queries must be identical.

look
B/Table
Excel.