I have two tables (Tab1 and Tab2) I want to know the new data records in Tab1, which is not available in Tab2 and the data records which are available in Tab2 but not I know Tab1.

I'm looking for a solution but not one with a loop, because I have large data and the loop takes a long time.

I think of something like (Selecht Tab1 where not exist in tab2),

(select Tab1 where not exisit (select tab2)) or

(select Tab1 left join Tab2 on ....... where Tab2.ID is null)

is it possible to query with Ninox Sql or join on tablets but not with a loop ???

Thanks for the answer

Maisam