select a.emp_no,
        a.salary,
        a.from_date,
        a.to_date,
        b.dept_no
from dept_manager as b  join salaries as a on b.emp_no = a.emp_no