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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
