find duplicates

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

Guest

i know there is a query called find duplicate records in a table or query.
but is there
a way to find duplicate numbers between 2 tables the data is different in
the two tables but they have common number field and i want to find the
ones that are duplicates how can i do this? any help is appreciated
 
Do you mean you want to find all the records in table 1 that have a
corresponding record in table 2 based on the number field between the two
being the same? That sound like a standard inner join to me.
 
Back
Top