select salaries.emp_no,salary,from_date,salaries.to_date,dept_no
from salaries right join dept_manager on (salaries.emp_no = dept_manager.emp_no)
order by salaries.emp_no