子查询就完事了！！！冲！！！！

select dd.dept_no,dd.emp_no,s.salary
from salaries as s inner join
                   (select d.dept_no,ee.emp_no
                    from dept_emp as d inner join(select e.emp_no 
                                                  from employees as e 
                                                  where e.emp_no not in 
                                                  (select emp_no from dept_manager)) as ee
                    on d.emp_no=ee.emp_no) as dd
on dd.emp_no=s.emp_no