select d.dept_no,d.emp_no,s.salary from dept_emp d,salaries s
where d.emp_no=s.emp_no and 
d.emp_no not in
(select emp_no from dept_manager);