用exists:
select * from employees e
where not exists
(select emp_no from dept_emp d where d.emp_no = e.emp_no);
不用exists:
select * from employees e
left join dept_emp d on d.emp_no = e.emp_no
where d.emp_no is null;
用exists:
select * from employees e
where not exists
(select emp_no from dept_emp d where d.emp_no = e.emp_no);
不用exists:
select * from employees e
left join dept_emp d on d.emp_no = e.emp_no
where d.emp_no is null;