Thanks. That worked smooth as silk! -----Original Message----- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:42 AM To: Peter Lauri Cc: mysql@lists.mysql.com Subject: Re: where group and inner join
In the last episode (Apr 19), Dan Nelson said: > It's useful to note that SELECT statements generally work in the > order they are written. The WHERE clause applies to the records as > they are read from the source tables, and at that point, no grouping > has been done, so there's no sum. Try moving your filter to a HAVING > clause, which comes between GROUP BY and HAVING, and applies to the "which comes between GROUP BY and ORDER BY", of course :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]