题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
查找所有员工的last_name和first_name以及对应的dept_name
http://www.nowcoder.com/practice/5a7975fabe1146329cee4f670c27ad55
三表连续连接
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;