Compares records

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
 
J

JethroUK©

the numbers must be the same on a join by definition

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