Hi,
Not sure where to begin, queries are my weakness!
I have two tables, one is "Master", other is "Actual". Both have a field "Code". Only ACTUAL has a field "POSITION"
I need to return a list of all items inside ACTUAL where the code in ACTUAL does not equal the code for that same item in MASTER, as well as return it's associated fields ("POSITION") in ACTUAL.
I was able to compare them using the query wizard which resulted in a left join, but that compared them completely, not sure how to add criteria to filter them for results where ActualCode <> MasterCode.
Here is schema info:
1.) MASTER may contain thousands of ItemIDs (speed important) - But the ItemID in master will ALWAYS be unique
2.) ACTUAL may only contain a dozen or two ItemIDs - But may have duplicate IDs with varying codes
3.) There is a possibility that an ItemID in ACTUAL may not exist in MASTER - and I would love a way to identify this occurrence in the resultant query.
Attached is test DB + images of expected results.
Thanks for any help!