题解 | #查找所有已经分配部门的员工

select last_name,first_name,dept_no
from employees as e
left join dept_emp as d on e.emp_no = d.emp_no
where e.emp_no in(select emp_no from dept_emp);

在原本的查询中嵌套子查询