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