select bb.dept_no,bb.emp_no,dd.salary from employees aa left join dept_emp bb on aa.emp_no=bb.emp_no left join dept_manager cc on bb.emp_no=cc.emp_no left join salaries dd on dd.emp_no=bb.emp_no where cc.emp_no is null