| Subject | How do you 0/null results to a GROUP BY query |
|---|---|
| Author | cornievs |
| Post date | 2012-10-24T21:54:25Z |
Hi All
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to also include the dates with zero sales, for example:
YEARNO DAYNO SUM
2012 01 5000
2012 02 6000
2012 03 0 (or null will be fine)
2012 04 7000
etc.
Any help will be appreciated!
Cornie van Schoor
InfoStar Software
I have query which extract the sales per day from a table
Select EXTRACT(YEAR from DT) as YEARNO, EXTRACT(YEARDAY from DT) AS DAYNO, SUM(DUE) from CLIENT_INVOICES group by YEARNO, WEEKNO.
It works 100%, but only returns the dates with sales, I need it to also include the dates with zero sales, for example:
YEARNO DAYNO SUM
2012 01 5000
2012 02 6000
2012 03 0 (or null will be fine)
2012 04 7000
etc.
Any help will be appreciated!
Cornie van Schoor
InfoStar Software