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

select t2.last_name,t2.first_name,t2.dept_name from (select t.*,d2.dept_name from (select e.emp_no,d1.dept_no,e.last_name,e.first_name from employees e left join dept_emp d1 on e.emp_no=d1.emp_no)t left join departments d2 on t.dept_no= d2.dept_no)t2;