Thanks for the help, folks. I see how the reference tables (either for the dates or the possible number of days in the range) would work -- pretty slick solutions. I worry about tables like that being able to scale, though, should a user choose a large date range... I think, instead, I'll use the standard query and then handle any gaps (non-existent dates) programmatically -- in the application, I'll check from row-to-row if we've skipped a date and, if so, display the date with a 0. No extra tables and easily commented to explain what's happening.
Thanks again! J --------------------- Ah, yeah. Okay, that's right. So then you *will* need to do it programmatically ... OR ... create a reference table that lists each of the dates in which you're interested. Then do a LEFT JOIN against that. Filter: query, queries, smallint --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
