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: [email protected]
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]
