构建两个临时表with employ as (select dep.emp_no,dep.dept_no,a.salaryfrom dept_emp depleft join salaries aon dep.emp_no = a.emp_nowhere dep.to_date = '9999-01-01'and a.to_date = '9999-01-01'and dep.emp_no not in (select emp_no from dept_manager where to_date = '9999-01-01')),manager as ...