Comparing two different tables with a query and display what doesnt match based on serial number.
Posted on 2012-08-30
I have a table called tblMODKits it has a field called MODKit.
I have a table called tblMODHistory it also has a field called MODKit. They are bothed Joined by the field MODKit.
This query goes through all the records and shows what all the records dont have.
I need a query that is based on the serial number. And shows what each serial number doesn't have. This takes the group as a whole and shows what the whole table doesnt have .
When I put based on the serial number it shows nothing. I am thinking because one table the MODKits doesnt have a field called Serial Numbers.
SELECT tblMODKits.[MOD Kit], tblMODKits.MWO, tblMODKits.[Part Number]
FROM tblMODKits LEFT JOIN tblMODHistory ON tblMODKits.[MOD Kit] = tblMODHistory.[MOD Kit]
WHERE (((tblMODHistory.[MOD Kit]) Is Null));
How can I show what each mod kit based on the serial number doesnt have?