Query (Very Urgent)

hI,

  I am not able to run a query(correlations) like this

*********************************************************
Table Name                      Primary key
----------------                -----------
SI_Accounts acct                accountid
SI_ActiveUnavailableFund_v      accountid, serialno






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 when I converted into 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 ---Very urgent.....

_________________________________________________________________
Design your own holidays. Make memories that last a lifetime. 
http://www.flexihols.com/2003/index.php Enjoy!