select t1.dept_no,t.emp_no,t2.salary
from employees t
left join dept_emp t1
on t.emp_no=t1.emp_no
left join salaries t2
on t.emp_no=t2.emp_no
where t.emp_no not in (select t3.emp_no
                       from dept_manager t3
                       left join dept_emp t4
                       on t3.emp_no=t4.emp_no)