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

select dept_no,a.emp_no,salary
from 
(select dept_no,emp_no from dept_emp
where emp_no not in (select emp_no from dept_manager)
group by dept_no
)a --取出不是manager员工ID
left join 
(select emp_no,salary from salaries)b
on a.emp_no=b.emp_no