select de.dept_no,e.emp_no,s.salary from employees e
INNER join dept_emp de on de.emp_no=e.emp_no
and (de.dept_no,de.emp_no) not in(select dept_no,emp_no from dept_manager)
inner join salaries s on s.emp_no=e.emp_no