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