Finally, in recent full release of MySQL 4.1, <a href="http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html" target=new window">subqueries are given full support. News that will surely make web database hacks the World over happy ;-)
I have been writing about web technology and software development since 2001. I am the developer of the Alpha Framework for PHP. I love open source, technology, and economics. You can follow updates from this blog on Twitter.