Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Different results between Oracle 8.1.7 and 9.2
> > SELECT REFISO.ISO FROM REFISO WHERE REFISO.ISO NOT IN ( SELECT
AMRATE.ISO
> > FROM AMRATE WHERE 'X' = 'Y')
> >
> Did you use single-quotes around the X? Try it again with double quotes
> around the X, then again without any quotes around the X. Same results?
Yes, I uses single quotes. Without it does not make sense because here we
have only a string comparission. Inside the the other statement I used a
existing colume comparing with a not existing value. Thatb means both
subselects returns an empty list
regards
Nicolas
Received on Mon May 17 2004 - 17:20:21 CDT
![]() |
![]() |