题解 | #获取所有员工当前的manager#

select t1.emp_no,t2.manager from( select emp_no,dept_no from dept_emp )t1 inner join ( select emp_no as manager,dept_no from dept_manager )t2 on(t1.dept_no=t2.dept_no) where t1.emp_no != t2.manager