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

三表连续连接

select t.last_name,t.first_name,h.dept_name from employees as t left join dept_emp as c on t.emp_no=c.emp_no left join departments as h on c.dept_no=h.dept_no;