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

利用两表salaries，dept_manager主键emp_no连接两张表,并用WHERE作为条件限制，order by作为排序；

SELECT salaries.emp_no, salaries.salary, salaries.from_date, salaries.to_date, dept_manager.dept_no 
FROM salaries,dept_manager 
WHERE salaries.emp_no = dept_manager.emp_no
AND dept_manager.to_date = "9999-01-01"
AND salaries.to_date = "9999-01-01"
ORDER BY salaries.emp_no