Re: SQL and IN

From: Christoph Seidel <christoph.seidel1_at_gmx.de>
Date: Mon, 30 Jun 2003 12:07:03 +0200
Message-ID: <bdp233$u7jem$1@ID-143718.news.dfncis.de>

Billy Verreynne wrote:

> If I understand you correctly, it is like showing the number of
> widgets (e.g. invoices, calls, claims, whatever) per day.
>
> However, for certain days, there may be no widgets. You want however
> to see that, e.g.

Yes.

> To do this type of thing, I usually create a second table...

> You do an outer join between the date table and the widget table

Well, but i do not have a second table to join with, that's the point. Received on Mon Jun 30 2003 - 05:07:03 CDT