SELECT s.emp_no, salary, from_date, s.to_date, dept_no
FROM salaries s
INNER JOIN dept_manager d on s.emp_no = d.emp_no
ORDER bY s.emp_no asc