How to list down a record where the data is found in one table but not in another table

[limfungkeat]

Dear gurus 

There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.

I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'

In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ ! 

[marcus_sommer]

exists() refers always against the already loaded field-values. Therefore the order of the load-statements as well as the cardinality of the field-values will have an impact. Just being aware of this makes it possible to develop in nearly each scenario an appropriate logic.

Simpler is often to resolve such tasks with a mapping-approach - in your case it might be:

t1: load * from Staff;
m: mapping load distinct UserId, 1 resident t1;
t2: load *, applymap('m', UserId, 0) as Flag from Submission;