Merge 3 tables

[ptrifile]

I am having a problem that should have a simple solution to but I just cant figure it out. I have 3 different tables all have the same exact structure and I just want to merge them into one table. I have tried an append query but I get an invalid argument error. Can someone show me the proper way to merge these 3 tables together?? thanks in advance!!

Paul

 

[PHV]

Have a look at UNION query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ptrifile]

Thanks PHV! Maybe you can help me with this. The following is the SQL that I used and the problem Im having is that its not pulling all of the data from each table, it seems to be excluding some.....Can you tell me if my SQL statement should be revised?

SELECT [case#],[contacted],[unabletoreach],[wrongphone]
from [recert_july]
UNION 
Select  [case#],[contacted],[unabletoreach],[wrongphone]
from [recertaugust]
UNION 
Select  [case#],[contacted],[unabletoreach],[wrongphone]
from [recert_september];

Thanks again!!

Paul

 

[PHV]

use UNION ALL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886