select 
*
from employees e

where not exists 
(
    select *
    from dept_emp d
    where d.emp_no = e.emp_no 
) # not exist ；子查询对于两张表能匹配的对象返回TURE值，然后not exist对于TRUE对象进行排除