> I have no idea what you are asking, which may explain why no one has replied > to your question yet. > > I've been working with relational databases for 20 years and I've never > heard the term "calendar table". What are you trying to accomplish? If you > describe clearly what you are trying to do, perhaps someone can help you > devise a way to do it in MySQL. > > Rhino > > >A table of dates to which to join other tables, >ensuring reports that reflect days for which no >data is available.
I forget the query but I know it can be done. But can't you just have a table (called calendar?) with each entry having it's own row with a date column that gives whatever date you need in it and then other columns for any other details you need to have to go along with the date. After you have a table full of dates you can just do a query that will grab all the information and display it like a calendar and show you days that have information and days that don't have anything. I'll see if I can't find that query for you and explain it to you. jay