select
s.*,
m.dept_no
from dept_manager m left join salaries s
on m.emp_no=s.emp_no
order by s.emp_no asc