题解 | #查找当前薪水详情以及部门编号dept_no#
查找当前薪水详情以及部门编号dept_no
http://www.nowcoder.com/practice/c63c5b54d86e4c6d880e4834bfd70c3b
FROM dept_manager T1
INNER JOIN salaries T2 ON T1.emp_no = T2.emp_no
WHERE T1.to_date = '9999-01-01'
AND T2.to_date = '9999-01-01'
ORDER BY T1.emp_no;
INNER JOIN 关键字在表中存在至少一个匹配时返回行。用LEFT JOIN的时候一直报错，不知道啥原因，跟着敲了INNER JOIN