RE: Query (Very Urgent)

jain cj  wrote
> 
> 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.....

Well, during weekend this mailing list will be read only by few SAP Labs guys.
Therefore you should not expect to send mail on Saturday and have response 
by Monday morning. Despite this I was just checking this topic.
And with 7.4.3 there was no problem.
Which version do you use?

Elke
SAP Labs Berlin