MySQL 4.0 (the current stable brench) does not support subqueries.
This feature is present in the beta brench of MySQL, v4.1.
----- Original Message -----
From: "Oscar (TOMCAT)" <oscar.tomcat@stripped>
Sent: Thursday, September 04, 2003 11:45 PM
Subject: MAX in a SubSelect
I'm using MySQL 4.0.1 for Linux/Windows... I need to perform a query like
SELECT AVALIACAO, COUNT(AVALIACAO)
WHERE IDVERSAO = (SELECT MAX(IDVERSAO) FROM VERSOES WHERE DATA =
GROUP BY AVALIACAO
And its doesn't work in this version...
There is other way to do that ???
|• MAX in a SubSelect||TOMCAT)||5 Sep|
| • Re: MAX in a SubSelect||Leonardo Rodrigues Magalhães||5 Sep|