Can MySQL 5.0 do subqueries?

Yes. MySQL supports subqueries since version 4.1 See http://dev.mysql.com/doc/mysql/en/subqueries.html