How do I find the bad records ... to Enforce Referential Integrity

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I have two tables (previously created by someone else.
Both tables have a field call RecNO that should be common to both tables
on a one to many relationship.
Apparently there are RecNO entries in the 'many' that are not in the
'one' ... HOW DO I FIND THEM?
There are over 12,000 to look through and compare ... can I use a query?
 
Yes, you can use a query.

When you create a new query, one of the choices is the Unmatched Query
wizard. It will do the job for you.

Essentially it's an outer join between the two queries, where the one size
is Null.
 
Back
Top