select s.*, dept_no
from salaries s
join dept_manager d
on s.emp_no=d.emp_no
order by emp_no;