1.分析

2.代码

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