Duplicate field values in 2 tables

  • Thread starter Thread starter Ed
  • Start date Start date
E

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.
 
Ed said:
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.
Click to expand...

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.
 
Hi,
Sounds like you just need to use the unmatched query
wizard. It will walk you through the process.
 
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.
Click to expand...

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>
 
Back
Top