How to select elements from a table that don't exist joining another table from X++

If you want to select for example from EmplTable all the Employees that don't exist in PayrollEmployee
, use this :

  select emplid from empltable notexists join payrollemployee
              where empltable .EmplId == payrollemployee.EmplId ;