select
  last_name,
  first_name,
  dept_no
from
  employees e
  left join dept_emp d on e.emp_no = d.emp_no

注意一下表连接类型