Is there a way to check for duplicates between tables in a databa.

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

Guest

I have a large mailing database with 10 or 12 separate categories (tables).
I know how to check for duplicates within a table, but is there a way to
check for duplicates between tables?
 
I believe you would build a union query (basically makes one record source
out of two or more tables) then run your duplicate search from there.

My question would be why you made 12 separate tables instead of just putting
in a "category" field. That would more closely match normalized database
design.

Rick B
 
Back
Top