查找不在另一张表中的数据,思路:
1. not in + 子查询
select emp_no from employees where employees.emp_no not in (select emp_no from dept_manager )2. left join + is null
select e.emp_no from employees as e left join dept_manager as d on e.emp_no = d.emp_no where d.emp_no is null