One thing that I see is that you are using an alias in your where clause. >From the manual: > It is not allowed to use a column alias in a WHERE clause, because the column value > may not yet be determined when the WHERE clause is executed. See section A.5.4 > Problems with alias.
The other thing that I see is that Max() is an aggregate function and that you do not have a group by clause. I would think that this query wouldn't run at all. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]