SELECT dm.emp_no ,s.salary ,s.from_date, dm.to_date ,dm.dept_no
from salaries as s inner join dept_manager as dm
on s.emp_no = dm.emp_no