subquery in mysql

subquery in mysql

A query that is used within another query. For example a select-statement within the WHERE or HAVING clause of another SQL statement. Mysql supporting the subquery system.