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]