Join two tables

[wgma]

I have 2 queries that return similar sets of records. Each query contains records that the other query contains. And each query contains records that the other query does not contain.

I need to be able to join the 2 queries and get a recordset that contain all of the information from both queries without duplicates.

I can do this with SQL but I am not familiar enough with Access to do the join since I am only given 3 types of joins.

Thanks,
wgma

 

[boblarson]

You would need a UNION query and just use the word UNION between the two parts and it will discard duplicates.

 

[neileg]

You would need a UNION query and just use the word UNION between the two parts and it will discard duplicates.

That's UNION as opposed to UNION ALL, which does preserve the duplicates.

 

[wgma]

The UNION worked great. Thanks.