For getting records present in Table2 but not in Table1,

you need to join these two tables using left outer join as:

Select A.*

from Table2 A left outer join...

since we have many threads, which may concurrently try to insert a record to this table, thus I have used this lock to prevent this from happening