Combine 3 separate tables

  • Thread starter Thread starter SKB
  • Start date Start date
S

SKB

I have three tables that represent three separate mailing lists
(converted from text files). Many of the people are in all three lists.
Currently each table contains name and address information with a unique
yes/no field for their list.

Is there an easy way to combine the three tables into one table showing
which lists they are in.

for example

This;
Table1
Name| list1
yes

Table2
Name| list2
no

Table3
Name| list3
yes

To this;

Table
Name| list1| list2| list3
yes no yes

If I can just get pointed in the right direction it would be great!
Thanks in advance for any help,

SKB
 
Several ways to do it. One is to first use a UNION query. I build a TEMP
table with all the names by appending all names into the TEMP.
Next use a TOTALS query with the TEMP table left join to the other three.
 
Back
Top