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

From: <ron_at_oracle-dba.co.uk>
Date: 2000/06/29
Message-ID: <8jfhja$6nu$1@nnrp1.deja.com>#1/1

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.

Ron Chennells

In article <3959413e.5520978_at_news.mindspring.com>, nitefrog_at_yahoo.com wrote:
> Why does this query not return any rows? I cant figure this one out?
> Also I want to note that the tablespaces are full or very close to
> being according to the storage manager. Will this cause the problem?
> Also this query takes for ever to run as well. Any help is greatly
> appreciated.
>
> select patientid
> from B
> where patientid not in (select patientid from A);
>
> TABLE A - patientid
> -------
> 1
> 2
> 3
> 4
>
> TABLE B - patientid
> -------
> 1
> 2
> 3
> 4
> 5
> 6
> 7
>
> Thanks,
>
> Kev.-
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 29 2000 - 00:00:00 CDT