查找不在另一张表中的数据,思路:
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 
京公网安备 11010502036488号