View containing all days since day X

From: Björn Wächter <Bjoern.Waechter_at_p3-solutions.de>
Date: Fri, 20 May 2005 10:04:58 +0200
Message-ID: <3f5k1dF65bslU1@news.dfncis.de>

Hi all,

I have to generate some reportviews.
The report shall show one row for each
day since day X. Since the tables where
I get the information from don't have
to have an entry for each day I don't
know how to generate the row for
missing days.

An example:

Table BIRTHAY:

| DAY | Born_Baby |

---

| 2005-11-01 | Alex |
| 2005-11-01 | Olli |
| 2005-11-01 | Marc |
| 2005-11-03 | Tom |
| 2005-11-04 | Sven |
| 2005-11-04 | Bjoern |

SELECT
DAY,
COUNT(*) BORN
FROM
BIRTHAY
GROUP BY DAY; Result:

| DAY | BORN |

---

| 2005-11-01 | 3 |
| 2005-11-03 | 1 |
| 2005-11-04 | 2 |

The problem is that I need the
row with the entry:

| DAY | BORN |

---

| 2005-11-02 | 0 |

How can I get the row?

Thanks Björn Received on Fri May 20 2005 - 03:04:58 CDT