Re: MAX in a SubSelect

[Leonardo Rodrigues Magalhães]

        MySQL 4.0 (the current stable brench) does not support subqueries.
This feature is present in the beta brench of MySQL, v4.1.

http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#ANSI_diff_Subqueries

    Sincerily,
    Leonardo Rodrigues

----- Original Message ----- 
From: "Oscar (TOMCAT)" <oscar.tomcat@stripped>
To: <mysql@stripped>
Sent: Thursday, September 04, 2003 11:45 PM
Subject: MAX in a SubSelect


Hi,

I'm using MySQL 4.0.1 for Linux/Windows... I need to perform a query like
this:

SELECT AVALIACAO, COUNT(AVALIACAO)
FROM AUDITORIAS
WHERE IDVERSAO = (SELECT MAX(IDVERSAO) FROM VERSOES WHERE DATA =
'2003-08-23')
GROUP BY AVALIACAO

And its doesn't work in this version...

There is other way to do that ???