select b.*,a.dept_no from dept_manager a left join salaries b on a.emp_no = b.emp_no order by b.emp_no;