select * from employees e
where not exists (select emp_no from dept_emp d where d.emp_no=e.emp_no)

思路：了解exists关键字，其实该题直接用外连接，判断是否为null更简单