Need Help with SQL

Hello Oracle Users,

I would like to write a query similar to the one below, but Oracle does not accept 'IF' statement. Is there anyother way to write a query similar to the one below.

select a.score , (If b.score in (11,12,13)) as InActive, (If b.score NOT in (11,12,13) as Active, sum(b.Balance)

from OldTable a, NewTable b
group by a.score;

Thanks,

Anna Henson Received on Thu Jan 11 2001 - 16:08:48 CST