select d.emp_no,s.salary ,s.from_date,s.to_date,d.dept_no
 from salaries as s inner join dept_manager as d on s.emp_no=d.emp_no
 order by emp_no asc;

1.使用inner join 连接构造新表，直接查询相应信息即可