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