Re: Why doesnt this query work?? Makes no sense????

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 2000/07/01
Message-ID: <8jkvop$4l5$1@nnrp1.deja.com>#1/1

In article <8jfhja$6nu$1_at_nnrp1.deja.com>, ron_at_oracle-dba.co.uk wrote:
> I had the same thing a while ago and thought I was going mad.
> I then tried it with the NOT EXISTS and got the expected results.
> I assumed it was a bug ( 8.0.5) and left it at that.
>

not a bug.
you had a null.
see http://www.deja.com/=gh/threadmsg_md.xp?AN=639788137&fmt=text

> Ron Chennells
>
> In article <3959413e.5520978_at_news.mindspring.com>,--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries Howtos and such: http://osi.oracle.com/~tkyte/index.html Oracle Magazine: http://www.oracle.com/oramag Opinions are mine and do not necessarily reflect those of Oracle Corp

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Jul 01 2000 - 00:00:00 CDT