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

select a.emp_no as emp_no,
b.emp_no as manager
from

(
    select
        *
    from
        dept_emp
) a
left join (
    select
        *
    from
        dept_manager
    
) b
on a.dept_no=b.dept_no
where a.emp_no <> b.emp_no