# select # e.emp_no# from # employees e left join dept_manager d # on e.emp_no=d.emp_no # where # d.emp_no is null /*
核心:连接之后找null
where is null; null比较特殊
*/select em.emp_no
from employees em
leftjoin dept_manager de on em.emp_no = de.emp_no
where de.emp_no isnull