select a.dept_no,a.emp_no,salary
from
salaries s
right join 
(select emp_no,dept_no 
from dept_emp de
where emp_no not in (select emp_no from dept_manager dm)) as a
on s.emp_no =a.emp_no