Compares records

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

Anyone know how to write a query to compare two fields that are joined 1:1.
I have two tables joined on Project number and I want to know where the
difference exists in the PO number from both fields.
Thanks
 
the numbers must be the same on a join by definition

to find any orphans change the join to inner or outer join
 
Back
Top