题解 | 获取所有非manager员工当前的薪水情况
SELECT b.dept_no,a.emp_no,c.salary FROM employees a LEFT JOIN dept_emp b ON a.emp_no = b.emp_no LEFT JOIN salaries c ON a.emp_no = c.emp_no WHERE a.emp_no NOT IN ( /找出非manager员工的emp_no SELECT DISTINCT emp_no FROM dept_manager ) PS:可以用子查询也可以用链接