Correlated query

hI,

   I am not able to run a query like this

*********************************************************
SELECT
    acct.accountId,  (acct.acctbalance - (Select sum(Amount) from 
SI_ActiveUnavailableFund_v  where AccountId = acct.AccountId)) Balance  from 
SI_Accounts acct

*********************************************************

It could successfully running in oracle. but in sapdb it throws an error 
like


getting an error like

---- Error -------------------------------
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-7011 POS(51) Correlated subquery not allowed.
SELECT
    acct.accountId,  (acct.acctbalance - (Select sum(Amount) from 
SI_ActiveUnavailableFund_v  where AccountId = acct.AccountId)) b  from 
SI_Accounts acct
-------------------------------------------------------------------------------------


What I can do for running the query.
Please help

_________________________________________________________________
Are you a geek? Are you a techno freak? http://www.msn.co.in/Computing/ 
Welcome home!