题解 | #查找所有员工的last_name和first_name以及对应部门编号dept_no#
查找所有员工的last_name和first_name以及对应部门编号dept_no
http://www.nowcoder.com/practice/dbfafafb2ee2482aa390645abd4463bf
考点：left join (since the question mentioned to include employees that haven't been assigned departments, we want to include these employee ids with "NULL" values)
select e.last_name, e.first_name, d.dept_no
from employees e
left join dept_emp d
on e.emp_no = d.emp_no
Momenta公司福利 297人发布
查看13道真题和解析
