Re: Need help with query. Doesnt work and dont know why?

well it looks ok, but this would be better:

SELECT patientid FROM b
MINUS
SELECT patientid FROM a

is this your full query? or are you simplifying another one? good luck
Randy

"The NiteFrog.-" 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.-
Received on Wed Jun 28 2000 - 00:00:00 CDT