Find records not found in INNER Join

[ItsMe]

I am running updates on my tblFasTrakTrans using multiple sets of criteria from tblMaster. I have several different sets of criteria that I can not update in a single pass. The result is I have some orphans in tblFasTrakTrans.



I want to focus on the remaining records in tblMaster that DO NOT have their PK in the respective FK field for tblFasTrakTrans

Is there a way I can employ an Inner Join query like this….

SELECT tblMaster.KeyPK, tblFasTrakTrans.IDPK, tblFasTrakTrans.KeyFK
FROM tblMaster INNER JOIN tblFasTrakTrans ON tblMaster.KeyPK = tblFasTrakTrans.KeyFK;

to then find records in tblMaster that do not have a foreign key in tblFasTrakTrans?


.
Thanks for any sugestions.

[pbaldy]

Sounds like you want the unmatched query wizard (the frustrated left join method). Or am I goofed up?

[ItsMe]

I have never tried the Unmatched Wizard before. I launch the Wizard and it asks a bunch of questions. I keep answering yes and clicking the tables, etc. All the time I am thinking, great this is what I need. After the wizard is done it gave me the results I am looking for.

Then I look at the SQL and start to kick myself. I know I built out a left join like this prior! Anyway, thanks for all of your help. If anything, you and the wizard has helped talk me through this.

I am going to keep the thread open a little longer and run the results through the gauntlet of "fun times". Hopefully I am overcomplicating things and will use this left join query to create an elegant approach.

[pbaldy]

Happy to help!

[ItsMe]

That is what I needed. A left Join and criteria of Null for the FK.

Paul,

Thank you for taking the time to read my question and then understanding it too.