Unmatched query sql code

[0243906]

Im trying to fing missing reports in my database using and think i need to use an unmatched query, the problem is this add-on is not installed on my system and to get the IT department to do anything is a real pain. Can some one tell me the SQL code for an unmatched query.

 

[lupins46]

Select * from table1 left join table2 on
table1.field= table2.field where table2.field is null

(Table 1 has all the records; table2 has some missing)