le subquery sono supportate da mySQL >= 4.1:
http://dev.mysql.com/doc/refman/5.0/en/subqueries.html