用子查询与外连接

SELECT A.last_name,A.first_name,mp.dept_name
from departments mp RIGHT JOIN (
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 ) as A
on mp.dept_no=A.dept_no;