select dept_no, salaries.emp_no, salary
from salaries left join dept_emp on salaries.emp_no=dept_emp.emp_no
where salaries.emp_no not in (select emp_no from dept_manager)