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

select a.emp_no,b.emp_no as manager
from (dept_emp as a left join dept_manager as b
on a.dept_no=b.dept_no)
where a.emp_no!=b.emp_no

不相等的关系用‘！=’表示