SQL11 获取所有员工当前manager

image.png
解析：
SELECT e.emp_no, m.emp_no AS manager_no
FROM dept_emp AS e
LEFT JOIN dept_manager AS m
ON e.dept_no = m.dept_no
WHERE e.emp_no != m.emp_no;