题解 | #获取所有非manager员工当前的薪水情况#

SELECT
    de.dept_no,
    de.emp_no,
    s.salary
FROM dept_emp AS de INNER JOIN salaries AS s
        ON de.emp_no = s.emp_no /*联结部门表与薪水表*/
WHERE
    de.emp_no != (SELECT
                        dm.emp_no
                    FROM dept_manager AS dm
                  WHERE dm.dept_no = de.dept_no) /*关联子查询把员工从部门经理表中排除*/