Hi everyone,

Some query is not working when I use <> operatior.Want to know what I am doing wrong!!!

ORIGINAL ROWS:
----------------------
begin_bal bal final_bal
--------------- --------------- ---------------
-11950336.34 5818859.35 -6131476.99
61649.31 .00 61649.31
209853.33 .00 209853.33
30011365.04 498753.53 30510118.57
9205.00 .00 9205.00
20514769.90 .00 20514769.90
.00 .00 .00
.00 .00 .00
.00 .00 .00
-----------------------------------------
I want to get rid of rows which begin_bal and bal and finalBal =.00
so I gave this criteria which is not working

EX: select begin_bal ,bal, final_bal
from testing
where ((begin_bal <> .00) and
(bal <> .00) and
(final_bal <> .00))
order by fund,acct

This query is working as if I am using as OR operator and returning rows
begin_bal bal final_bal
--------------- --------------- ---------------
-11950336.34 5818859.35 -6131476.99
30011365.04 498753.53 30510118.57

GOT RID OF THE ROWS WHICH begin_bal or bal or final_bal =.00
---------------------------------------

But it worked when I used like this

select * from testing
where not(begin_bal = .00 and
bal = .00 and
final_bal = .00)
order by fund,acct


Anybody has comments on this!!!!


Thanks,
Jani