are there any other ways to say, for example
Where MemberNo NOT IN field
Printable View
are there any other ways to say, for example
Where MemberNo NOT IN field
not exists is similar
Also, MINUS
OUTER JOIN
Tamil
Are you sure NOT IN is what you want? The "code" you posted is not enough for me to distinguish between:Quote:
Originally posted by pepsipaul
Where MemberNo NOT IN field
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.
Size of the tables plays a major role in using the two.
http://asktom.oracle.com/pls/ask/f?p...D:953229842074