SELECT dm.emp_no,salary,from_date,dm.to_date as to_date,dept_no from dept_manager as dm left join salaries as sa
on dm.emp_no = sa.emp_no order by sa.emp_no asc

直接左连接就行