select s.emp_no, salary, from_date, s.to_date, dept_no from salaries s left join dept_manager m on s.emp_no = m.emp_no where dept_no is not Null order by s.emp_no ASC;