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

select d.dept_no,c.emp_no,e.salary
from (select a.emp_no,b.dept_no
from (employees as a 
left join dept_manager as b
on a.emp_no=b.emp_no)
where b.dept_no is null) as c
left join dept_emp as d
on c.emp_no=d.emp_no
left join salaries as e
on c.emp_no=e.emp_no

一直卡在中间的第一个select，要尽量具体，还是找不到用*号的机会

但其实还是想不明白为什么不可以只用后面三个表查找，下面代码能运行，但是结果是错的

select d.dept_no,c.emp_no,c.salary
from (select a.emp_no,a.salary,b.dept_no
from (salaries as a 
join dept_manager as b
on a.emp_no=b.emp_no)
where b.dept_no is null) as c
left join dept_emp as d
on c.emp_no=d.emp_no