题解 | #查找当前薪水详情以及部门编号dept_no#

SELECT s.emp_no,s.salary,s.from_date,s.to_date,d.dept_no FROM salaries s RIGHT OUTER JOIN dept_manager d ON s.emp_no=d.emp_no AND s.to_date='9999-01-01' AND d.to_date='9999-01-01' ORDER BY s.emp_no ASC