'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




Oracle LazyDBA home page