hi
doesnt mysql support subqueries???
finger
no, it doesn't. No triggers or stored procedures either. Transactions are only supported in a fairly primitive mode too.
If you need sub selects, and all that other stuff, look at postgresql.