Hello MySQL-users ! Houston, I've got a problem here.
I'm running the following query from a PHP-Script: SELECT years.year AS yearlist, count(years.year) AS gamecount FROM years LEFT JOIN games ON years.year = games.release_year GROUP BY years.year ORDER BY gamecount DESC, yearlist This query should do the following: Every year from years.year should be returned along with the number of games that have been released in that year sorted by the gamecount. years.year and games.release_year both do NOT contain NULL. The problem is the following: Years in which no games were released are returned with a gamecount of 1. Why that??? All other years with games released in it are getting the correct gamecount. Please help me. Greetings from Germany, Jens Mildner. --------------------------------------------------------------------- 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
