Try using a Union then...

SELECT snseq FROM FSNE WHERE
SNPUB = 'NYT' AND SNPUBDT = '02-MAY-06' AND SNEDTN = 'FULL RUN'
UNION
SELECT snseq FROM FSNE WHERE
SNPUB = 'LIN' AND SNPUBDT = '29-MAY-06' AND SNEDTN = 'FULL RUN';

But, it does seem peculiar. I would expect the same results for using
the OR as I would from using the union.



-----Original Message-----
From: Qi cheng
[mailto:oracledba-ezmlmshield-x78815581.[Email address protected]
Sent: Wednesday, September 27, 2006 2:35 PM
To: LazyDBA Discussion
Subject: Re: weird sql result

I need OR here. And will not work in this case.(I tested, return none)

Seems oracle oracle care about the condition before OR , if I switch the
condition after OR to begin, it return other part of records.

On 9/27/2006 2:27 PM, McCarthy Kendall
<oracledba-ezmlmshield-x30684462.[Email address protected] wrote:
>'OR' to 'AND'
>
>-----Original Message-----
>From: Qi cheng
>[mailto:oracledba-ezmlmshield-x36818603.[Email address protected]
>Sent: Wednesday, September 27, 2006 2:24 PM
>To: LazyDBA Discussion
>Subject: weird sql result
>
>
>SQL> SELECT snseq FROM FSNE WHERE SNPUB = 'LIN' AND SNPUBDT =
'29-MAY-06'
>AND SNEDTN = 'FULL RUN' ;
>
> SNSEQ
>----------
> 355078
> 57663
>
>SQL> SELECT snseq FROM FSNE WHERE
> 2 SNPUB = 'NYT' AND SNPUBDT = '02-MAY-06' AND SNEDTN = 'FULL RUN';
>
> SNSEQ
>----------
> 72018
> 367620
> 72018
>
>But the following not show 355078 and 57663:
>SQL> SELECT snseq FROM FSNE WHERE
> 2 (SNPUB = 'NYT' AND SNPUBDT = '02-MAY-06' AND SNEDTN = 'FULL
>RUN') OR
> 3 (SNPUB = 'LIN' AND SNPUBDT = '29-MAY-06' AND SNEDTN = 'FULL
>RUN' );
>
> SNSEQ
>----------
> 72018
> 367620
> 72018
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page