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

SELECT d.dept_no, e.emp_no, s.salary
FROM employees AS e
    JOIN dept_emp AS d ON e.emp_no = d.emp_no
    JOIN salaries AS s ON e.emp_no = s.emp_no
WHERE e.emp_no NOT IN (SELECT DISTINCT emp_no FROM dept_manager);