SELECT
  d.emp_no,
  d.salary,
  d.from_date,
  d.to_date,
  de.dept_no
FROM
  salaries d
LEFT JOIN dept_manager de
ON
  d.to_date = de.to_date AND d.emp_no = de.emp_no
WHERE
  de.emp_no IS NOT NULL