Re: Query to total
From: HeadLessBoot <headless_at_seattle.us.maybe>
Date: Fri, 20 May 2011 11:36:29 +0200
Message-ID: <4dd63628$2_at_news.x-privat.org>
HeadLessBoot, on 05/20/2011 11:33 AM, wrote:
Date: Fri, 20 May 2011 11:36:29 +0200
Message-ID: <4dd63628$2_at_news.x-privat.org>
HeadLessBoot, on 05/20/2011 11:33 AM, wrote:
> SELECT *
<CUT>
> , (
> SELECT SUM(NUMERICFIELD3) FROM THE_VIEW
> ) AS TOTAL3
> , (
> SELECT SUM(NUMERICFIELD4) FROM THE_VIEW
> ) AS TOTAL4
Sorry, I obviously forgot to end it all with
FROM DUAL
Received on Fri May 20 2011 - 04:36:29 CDT