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 dept_manager.emp_no