Subquery

A subquery is a bracketed SELECT statement within another outer statement. The outer statement can be any one of SELECT, INSERT, UPDATE, DELETE, SET or DO.
A subquery sometimes becomes useful when it is impossible to formulate a query using JOIN otherwise. Sometimes it is also faster to use a subquery.