题解 | #last_namedept_name#
查找所有员工的last_name和first_name以及对应的dept_name
https://www.nowcoder.com/practice/5a7975fabe1146329cee4f670c27ad55
进行左连接
select a.last_name,a.first_name,c.dept_name
from
employees a
left join
dept_emp b
on a.emp_no=b.emp_no
left join
departments c
on b.dept_no= c.dept_no;
from
employees a
left join
dept_emp b
on a.emp_no=b.emp_no
left join
departments c
on b.dept_no= c.dept_no;
