题解 | #获取所有员工当前的manager#

select dept_emp.emp_no as emp_no, dept_manager.emp_no as manager_no
from dept_emp, dept_manager
where dept_emp.dept_no=dept_manager.dept_no
and dept_emp.emp_no!=dept_manager.emp_no
and dept_manager.to_date='9999-01-01';