A query that is contained within another query statement is called a subquery. Subqueries can also be called nested SELECTs or sub-SELECTs. In subqueries, the entire SELECT syntax is acceptable.