Unsure which version of MySQL you're using, but MySQL does support sub-queries.

If you can, upgrade to MySQL 5 - the documentation regarding sub-queries within the SELECT part of the query is allowed. (http://dev.mysql.com/doc/refman/5.0/en/subqueries.html)