select e.last_name,e.first_name,de.dept_name
from employees as e left join dept_emp as d on e.emp_no = d.emp_no
left join departments as de on d.dept_no = de.dept_no
题目解答多表外联结select e.last_name,e.first_name,de.dept_namefrom employees as e left join dept_emp as d on e.emp_no = d.emp_no left join departments as de on d.dept_no = de.dept_no