Following query shows all records those are available in table 1 but not available in table 2

SELECT * FROM [TABLE1] LEFT JOIN [TABLE2] ON [TABLE1][PK_ID] = [TABLE2].[FK_TABLE1]  WHERE [TABLE2].[FK_TABLE1] IS NULL