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