select a.emp_no, salary, from_date, a.to_date, dept_no
from salaries a join dept_manager b on a.emp_no=b.emp_no
order by a.emp_no