Joining queries together and deduping them

[sallyc]

I have 3 queries run from one file, they all have the same number of fields (from a large xls file i am trying to make amail file that meets 3 specific criteria). The 3 queries have worked fine but i know there are a few duplications between them.

I need to join all three queries together so they contain all the information but there are no duplicate rows.

I have joined them all together in excel and imported it back so it's all on one file, but i can't get rid of the duplications!!

CAn anyone give me any clues



Thanks a lot

 

[Mile-O]

Use a UNION query to join your stuff.

i.e.

SELECT * FROM tblA UNION SELECT * FROM tblB;