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

方法一: 

SELECT
    S.emp_no,
    S.salary,
    S.from_date,
    de.to_date,
    de.dept_no
FROM
    salaries AS S,
    dept_manager AS de
WHERE
    de.emp_no = S.emp_no
ORDER BY
    S.emp_No;



方法二:


SELECT
    S.emp_no,
    S.salary,
    S.from_date,
    de.to_date,
    de.dept_no
FROM
    salaries AS S
    INNER JOIN dept_manager AS de ON de.emp_no = S.emp_no
ORDER BY
    S.emp_No;