Not getting reply

>From: "jain cj" <[email protected]>
>To: [email protected]
>Subject: Query (Very Urgent)
>Date: Sat, 30 Aug 2003 05:45:26 +0000
>
>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!
>
>_______________________________________________
>sapdb.general mailing list
>[email protected]
>http://listserv.sap.com/mailman/listinfo/sapdb.general

_________________________________________________________________
Got a wish? Make it come true. 
http://server1.msn.co.in/msnleads/citibankpersonalloan/citibankploanjuly03.asp?type=txt 
Best personal loans!