subqueries / nested queries

[terence]

I understand that MySQL does not support subqueries or nested queries. Is there a 
simple workaround or do I have to do a number of queries and manipulate them outside 
of MySQL? I am using PHP for server side code. Where can I look for answers?

Terence