SELECT
d.dept_no,
d.emp_no,
s.salary
FROM
dept_manager d
INNER JOIN salaries s ON d.emp_no = s.emp_no
WHERE
d.to_date = '9999-01-01'
AND s.to_date = '9999-01-01'
04-04
671
04-11
347