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)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 ??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
