使用子查询明显比用联结要慢

select e.emp_no from employees e
where e.emp_no not in (select emp_no from dept_manager)

# select e.emp_no from employees e
# left join dept_manager dm
# on e.emp_no=dm.emp_no
# where dm.emp_no is null