Yes, that should show you the employees from OLDTABLE that are not listed in RUNTIMETABLE.

what you do with that join is: you tell the database to take the data from both tables and join them with the tablekey. You say: I want *every* Data joined.

e.g. (Employeenumbers):

RUN OLD
1 ----- 1
2 ----- 2

If there is data in OLDTABLE that is not in RUNTIMETABLE it looks like this:

RUN OLD
1 -------- 1
2 -------- 2
NULL -- 3
NULL -- 4

Does that help you?