代码:
SELECT dept_emp.emp_no, dept_manager.emp_no AS manager
FROM dept_emp INNER JOIN dept_manager
ON dept_emp.dept_no = dept_manager.dept_no
WHERE dept_emp.emp_no != dept_manager.emp_no
代码:
SELECT dept_emp.emp_no, dept_manager.emp_no AS manager
FROM dept_emp INNER JOIN dept_manager
ON dept_emp.dept_no = dept_manager.dept_no
WHERE dept_emp.emp_no != dept_manager.emp_no