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