Paul DuBois wrote:
>
> You need to create another table that has a row for each date in the
> range, then use that table in a LEFT JOIN to your original table
> to find rows in the date table that are not represented by your original
> table.
Thank you Paul, your sql table building script and
At 9:14 -0500 4/4/02, George Smith wrote:
>I have a mysql table like this
>mysql> describe reports;
>+-+-+--+-++---+
>| Field | Type| Null | Key | Default| Extra |
>+-+-+--+-++---+
>| rptdate | date|
I have a mysql table like this
mysql> describe reports;
+-+-+--+-++---+
| Field | Type| Null | Key | Default| Extra |
+-+-+--+-++---+
| rptdate | date| | PRI | -00-00 | |
| id | int(11