Finding missing items in a series

I have a mysql table like this mysql> describe reports; +-+-+--+-++---+ | Field | Type| Null | Key | Default| Extra | +-+-+--+-++---+ | rptdate | date| | PRI | -00-00 | | | id | int(11

Re: Finding missing items in a series

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