how to group by with a sql that has multiple subqueries
I am trying to add a group by to this statement:
SELECT SC_JOBS.CREATIONDATE,
(SELECT SUM(SC_JOBS.GROSSEXCLVAT) FROM SC_JOBS WHERE
SC_FRAMES.GROUPPRODUCTTYPE = 'ATI' AND SC_FRAMES.JOBID = SC_JOBS.JOBSID
AND SC_JOBS.INVOICEDATE < '1990-01-01') AS Product 1,
(SELECT SUM(SC_JOBS.GROSSEXCLVAT) FROM SC_JOBS WHERE
SC_FRAMES.GROUPPRODUCTTYPE = 'ATI' AND SC_FRAMES.JOBID = SC_JOBS.JOBSID
AND SC_JOBS.INVOICEDATE < '1990-01-01') AS Product 2
FROM SC_JOBS INNER JOIN SC_FRAMES ON SC_FRAMES.JOBID = SC_JOBS.JOBSID
WHERE SC_JOBS.CREATIONDATE BETWEEN :StartDate AND :EndDate ORDER BY
SC_JOBS.CREATIONDATE
Any suggestions please?
No comments:
Post a Comment