Perdón por la info erronea anterior:
Cita: Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific.
mysql.com
Bien con tu versión puedes intentar mirar esto:
http://dev.mysql.com/doc/refman/4.1/...imization.html