MySQL :: MySQL 5.0 Reference Manual :: 13.2.8 SELECT Syntax

See Section 9.5, “Expression Syntax”, and Chapter 12, Functions and Operators. ... For GROUP BY or HAVING clauses, it searches the FROM clause before ...

dev.mysql.com