Link to home
Start Free TrialLog in
Avatar of Bevos
Bevos

asked on

Access 2007: SQL question, compare two fields and report which values are not repeated

Hello, I would like to make a simple query in SQL that shows me which values for a field are not contained within both fields.  I have a table (tblRecordNumbers) with RecordNumberOld and RecordNumberNew fields.  Record number old has 675 entries and RecordNumberNew has 941.  I need to know what numbers in RecordNumberNew are not in record number old. Can anyone please explain how to do this?

Thanks,
Bevos
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

do a select query using a left join using the same table  

SELECT tblRecordNumbers.RecordNumberOld, tblRecordNumbers_1.RecordNumberNew
FROM tblRecordNumbers LEFT JOIN tblRecordNumbers AS tblRecordNumbers_1 ON tblRecordNumbers.RecordNumberOld = tblRecordNumbers_1.RecordNumberNew
WHERE (((tblRecordNumbers_1.RecordNumberNew) Is Null));
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bevos
Bevos

ASKER

Thanks so much Capricorn1, this works exaclty as intended.

Bevo