Re: Replace NOT IN w/ NOT EXISTS ?

In article <3dcl9c$cv7_at_info.eng.octel.com> dan.bikle_at_octel.com (Dan Bikle) writes:

>Hi there,
 

>select ename from emp
>where empno NOT IN
>(select empno from empexclude)
>/
 

>can be replaced by a quicker method.
>something like:

>select ename from emp
>where NOT EXISTS ...
 

>I forget the rest.
 

>Anyone got a demo?
 

>-Dan
>dbikle_at_alumni.caltech.edu

Try...

select ename from emp e
where not exists (select null from empexclude ex

                             where ex.empno = e.empno);

That should do it.

Scott Received on Thu Dec 22 1994 - 21:38:56 CET