Matthew Perkovic thinks this is interesting: Subqueries are always processed starting with the innermost SELECT statement and working outward. When the preceding SELECT statement is processed, MySQL actually performs two operations. From 14. Working with Subqueries from MySQL® Crash Course by Ben Forta Publisher: Sams Released: December 2005 Note Subqueries processed from right to left. Share this highlight http://www.safaribooksonline.com/a/mysql-crash-course/43626/ Twitter Facebook Google Plus Email Get Instant Access Now Start a Free Trial Learn about Safari for Business Have an account? Sign in. Minimise Unlock the rest of MySQL® Crash Course and 30,000 other books and videos By clicking this box, you confirm that you have read and agree to the terms and conditions of our Membership Agreement, and you understand that when your trial period ends, you will be required to provide billing information if you wish to continue using the service. Unlock the rest of this book Start a Free 10-Day Trial loading Learn about Safari for Business Have an account? Sign in.