select
  t1.dept_no,
  t1.emp_no,
  t3.salary
from 
	dept_emp t1
left join 
	dept_manager  t2 on t1.dept_no=t2.dept_no
left join
	salaries t3 on t1.emp_no=t3.emp_no
where
	t1.emp_no!=t2.emp_no