注意:员工表和经理表的to_date也要一样。
SELECT a.emp_no, b.emp_no FROM
dept_emp AS a JOIN dept_manager AS b
ON a.`dept_no`=b.`dept_no` AND a.`emp_no` != b.`emp_no` AND a.`to_date`='9999-01-01'
AND a.`to_date`=b.`to_date`;
注意:员工表和经理表的to_date也要一样。
SELECT a.emp_no, b.emp_no FROM
dept_emp AS a JOIN dept_manager AS b
ON a.`dept_no`=b.`dept_no` AND a.`emp_no` != b.`emp_no` AND a.`to_date`='9999-01-01'
AND a.`to_date`=b.`to_date`;