Replace NOT IN w/ NOT EXISTS ?
From: Dan Bikle <dan.bikle_at_octel.com>
Date: 22 Dec 1994 19:50:04 GMT
Message-ID: <3dcl9c$cv7_at_info.eng.octel.com>
Date: 22 Dec 1994 19:50:04 GMT
Message-ID: <3dcl9c$cv7_at_info.eng.octel.com>
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.
-Dan
dbikle_at_alumni.caltech.edu
Received on Thu Dec 22 1994 - 20:50:04 CET