题解 | #查找所有员工的last_name和first_name以及对应的dept_name#

select a.last_name,a.first_name,c.dept_name
from employees a
left join dept_emp b on b.emp_no=a.emp_no
left join departments c on b.dept_no=c.dept_no