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