题目:获取所有部门当前manager的当前薪水情况,给出dept_no,emp_no以及salary,当前表示to_date=‘9999-01-01'

INNER JOIN
SELECT d.dept_no, d.emp_no, s.salary
FROM dept_manager AS d
INNER JOIN salaries AS s
ON d.emp_no=s.emp_no
WHERE d.to_date='9999-01-01'
and s.to_date='9999-01-01'