Structure Means Subqueries: Nesting SELECTs in MySQL 4.1

(Trudy Pelzer) Effective with MySQL version 4.1, there are two ways in which one can get data from multiple tables in a single query: with a join and with a subquery.

Read More - Register for Free Membership