" A subquery is a SELECT statement inside another statement.

Starting with MySQL 4.1, all subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. "
http://dev.mysql.com/doc/mysql/en/subqueries.html