select dept_manager.dept_no, dept_manager.emp_no, salaries.salary from dept_manager, salaries
where salaries.emp_no=dept_manager.emp_no
and dept_manager.to_date='9999-01-01' and salaries.to_date='9999-01-01';