What I try to execute is: "SELECT ID,(SELECT SUM(PRICE) AS ALL_PRICES FROM MY_TABLE) FROM MY_TABLE"
Any hints?
The above query doesn't make any sense. Beside that, i beleive that it's a bug in the checks that SAPDB performs. There are really sub-queries that aren't allowed, but this one could be allowed, although the query returns the same as
SELECT a.ID, b.S FROM MY_TABLE a CROSS JOIN (SELECT SUM(PRICE) AS S FROM MY_TABLE) b
and this query might perform better that yours, because it takes of the fact, the sub-query only returns one row that contains the same value for all possible values if ID.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
