• 参考答案:
select e.last_name,e.first_name,d.dept_no 
from employees e LEFT JOIN dept_emp d
on e.emp_no = d.emp_no