select salaries.emp_no,salary,from_date,salaries.to_date,dept_no
from dept_manager left join salaries using(emp_no)
order by salaries.emp_no