Duplicate field values in 2 tables

[Ed]

I would greatly appreciate help on this issue!!!! I have
2 tables with identical field structures. Both tables
have a field that holds phone numbers. What I am trying
to do is run a make table query. I want to make a new
3rd table that contains all records from table one that
do NOT contain a matching phone number from table 2. In
other words, if table 1 has 100,000 records, of which
10,000 have a duplicated phone number in table 2, I want
table 3 to only produce the 90,000 records with a unique
phone number.

Help please!!!!!!!!!

Thanks.

 

[Bas Cost Budde]

I would greatly appreciate help on this issue!!!! I have
2 tables with identical field structures. Both tables
have a field that holds phone numbers. What I am trying
to do is run a make table query. I want to make a new
3rd table that contains all records from table one that
do NOT contain a matching phone number from table 2. In
other words, if table 1 has 100,000 records, of which
10,000 have a duplicated phone number in table 2, I want
table 3 to only produce the 90,000 records with a unique
phone number.

Help please!!!!!!!!!

Thanks.

You can do a left join on the tables, or have a query with a subselect
(NOT IN). The first is a little faster.

Try creating a new query with the query wizard, and then choose
Unmatched Query to see what this means.

 

[Les]

Hi,
Sounds like you just need to use the unmatched query
wizard. It will walk you through the process.

 

[John Vinson]

I would greatly appreciate help on this issue!!!! I have
2 tables with identical field structures. Both tables
have a field that holds phone numbers. What I am trying
to do is run a make table query. I want to make a new
3rd table that contains all records from table one that
do NOT contain a matching phone number from table 2. In
other words, if table 1 has 100,000 records, of which
10,000 have a duplicated phone number in table 2, I want
table 3 to only produce the 90,000 records with a unique
phone number.

Help please!!!!!!!!!

Thanks.

A "Frustrated Outer Join" query is the ticket here.

Create a query joining Table1 to Table2 by Phone. Select the join line
and choose option 2 - "Show all records from Table1, and matching
records from Table2". Select whatever fields from Table1 you want in
the output table, and *only* the Phone field from Table2; use a
criterion on this field of

IS NULL

to exclude those records which *do* have a match, leaving only the
ones that don't.

Uncheck the Show checkbox on this field, and change the query to a
MakeTable.

Pssst... if this is for a telemarketing table, add my phone number to
Table2 first <g>