Joining 2 tables (one w/new info, one w/old info)

[laina222]

I was wondering if anyone could help me with a query I needed to make. I have two tables, one is a call log where Customer Service Reps record the complaints that customers have. The other is the same table, only it stores the older complaint information that we've already published reports on. I want to join the new table information from a certain date through a certain date to the already existing older table of information. I know I can copy and paste all the records I needed into the old table but I was wondering if I could write a query that would add this functionality and save about three hours of my time.
Any ideas?

 

[JerryDennison]

Use a Union query.

 

[THoey]

Like Jerry said:

SELECT * FROM MyTable1
UNION
SELECT * FROM MyTable2

I would suggest that you combine the tables and then add a column that just lists whether or not it has been reported on, unless this is going to get too big.
Terry M. Hoey