how can I find duplicates in two tables based on phone number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table of 10,000 records and I have a second table of 500 records.
How can I run a query that tells me which of the 500 records are already in
the larger table?
 
See if this help:

select SmallerTable.ID
from SmallerTable
where (( select count(*) from LargerTable WHERE LargerTable.ID =
SmallerTable.ID ) > 0)

Mauricio Silva
 
I have a table of 10,000 records and I have a second table of 500 records.
How can I run a query that tells me which of the 500 records are already in
the larger table?
Click to expand...

Create a Query by adding both tables to the query grid. Join them on
the Phone field. Select whichever fields you want to see and open the
query in a datasheet, or base a Form or Report on it.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top