I am not able to run a query like this
*********************************************************
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 in 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
_________________________________________________________________
Are you a geek? Are you a techno freak? http://www.msn.co.in/Computing/ Welcome home!
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
