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