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

select
    a.emp_no as emp_no,
    a.salary as salary,
    a.from_date as from_date,
    a.to_date as to_date,
    b.dept_no as dept_no
from
    (
        select
            emp_no,
            salary,
            from_date,
            to_date
        from
            salaries
    ) a
    join (
        select
            dept_no,
            emp_no,
            to_date
        from
            dept_manager
    ) b
    on a.emp_no=b.emp_no