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.
http://dev.mysql.com/doc/mysql/en/subqueries.html

Da quanto capisco le subquery sono valide da MySQL 4.1 in su...