is there an alternative to SQL NOT IN

[pepsipaul]

are there any other ways to say, for example

Where MemberNo NOT IN field

[pando]

not exists is similar

[tamilselvan]

Also, MINUS
OUTER JOIN

Tamil

[DaPi]

Originally posted by pepsipaul
Where MemberNo NOT IN field

Are you sure NOT IN is what you want? The "code" you posted is not enough for me to distinguish between:
1) Where INSTR(field, MemberNo) = 0 <- where MemberNo and field are from the same row
2) Where MemberNo NOT IN (Select field From . . . )
as possibly correct coding.


Caution: NOT IN behaves non-intuitively (but logically) when the Select returns a NULL. Unless you've cracked that, NOT EXISTS is more likely to give the answer you expect.

[engiri]

Size of the tables plays a major role in using the two.

http://asktom.oracle.com/pls/ask/f?p...D:953229842074