Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SELECT - parenthesis ignored by Oracle ???

SELECT - parenthesis ignored by Oracle ???

From: Syltrem <syltrem_at_videotron.pas.de.spam.ca>
Date: Fri, 14 Dec 2001 11:51:48 -0500
Message-ID: <d7qS7.14057$a5.560440@wagner.videotron.net>


I do
select distinct(year || period)
from IC_BIN_MOVEMENTS
WHERE WAREHOUSE='SF'
AND (PERIOD<>10 AND YEAR<>2001);

That is, I want all rows where warehouse = SF and the date is not october 2001.
What it returns is all rows for warehouse SF where the period is not 10 (of any year) and year is not 2001.
As a result I get all months except october for every year, and nothing at all for the whole year 2001.

Why are the parenthesis ignored?

Thanks! Received on Fri Dec 14 2001 - 10:51:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US