Joining 2 mailing lists in query

[Ratatat]

I have a master mailing list in a table consisting of about 40,000 records
for about 50 different sales representatives. When a new sales person is
hired, they bring their own mailing lists in with them which cannot be added
to our master list. I would like, however, to have each individual list in
the database and be able to, when they want to do an individual mailing, pull
records from both their current and their old lists in one query. It seems
like it should be rather easy but I cannot figure out how to do it.

 

[debinnj]

Hi Ratat,
Have you tried a make table query? Join the two tables together via a
unique id (CustomerID) run the query to make sure it all lines up and then
run an action query (make table) That should do it.
Best,
Deb

 

[Ratatat]

Hi Deb,
Ok, I tried that but (unless I'm doing something wrong) there is no way to
pull the same field from both tables in the query.

Thanks