-
is there an alternative to SQL NOT IN
are there any other ways to say, for example
Where MemberNo NOT IN field
Paul
-
-
Also, MINUS
OUTER JOIN
Tamil
-
Re: is there an alternative to SQL NOT IN
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.
-
Size of the tables plays a major role in using the two.
http://asktom.oracle.com/pls/ask/f?p...D:953229842074
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|