R: SELECT - parenthesis ignored by Oracle ???

Hi!

It is not a parenthesis problem, it is a logic problem!

try this:

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

Syltrem <syltrem_at_videotron.pas.de.spam.ca> wrote in message d7qS7.14057$a5.560440_at_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 - 11:06:09 CST