SELECT s.emp_no,
s.salary,
s.from_date,
s.to_date,
d.dept_no
FROM salaries s
RIGHT JOIN dept_manager d ON s.emp_no = d.emp_no
order BY s.emp_no