MySQL SubQuery

Performs simple nested SELECT Statements with MySQL (for example, of the form SELECT * FROM x WHERE y IN (SELECT y FROM z WHERE ...) ) Subqueries must be enclosed in parenthe.