select sa.emp_no,sa.salary,sa.from_date,de.to_date,de.dept_no
from  salaries as sa right join dept_manager as de
on sa.emp_no = de.emp_no
order by sa.emp_no asc

但若字段名不唯一，则需要带表名！