List:General Discussion« Previous MessageNext Message »
From:Peter Lauri Date:April 20 2006 4:45am
Subject:RE: where group and inner join
View as plain text  
Thanks. That worked smooth as silk!

-----Original Message-----
From: Dan Nelson [mailto:dnelson@stripped] 
Sent: Thursday, April 20, 2006 11:42 AM
To: Peter Lauri
Cc: mysql@stripped
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
	dnelson@stripped

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
where group and inner joinPeter Lauri20 Apr
Re: where group and inner joinDan Nelson20 Apr
  • Re: where group and inner joinDan Nelson20 Apr
    • RE: where group and inner joinPeter Lauri20 Apr
Re: where group and inner joinPeter Brawley20 Apr