select a.dept_no,a.emp_no,c.salary
from dept_emp a
left join dept_manager b on a.emp_no=b.emp_no
join salaries c on a.emp_no = c.emp_no
where b.emp_no is null