> That would work, but it's not necessary. He should use a > LEFT JOIN, which will produce a row in the output for the > left table, whether or not any right table rows match it. > The syntax is in the MySQL manual.
I appreciate the pointer to LEFT JOIN and have read through the site's documentation on it. Unfortunately, I don't see how that will help me get the non-existent dates in there with a count of 0. As Nasser pointed out, there's nothing to do if no rows for those dates exist. In the case of using a LEFT JOIN, I don't get what I'd be joining my table to... Sorry for being dense, but any help you can provide is most appreciated. Thanks! J --------------------------------------------------------------------- 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