Sub-query

Sub-query is a part of a query that performs search on business objects other than those of the main query. For example, in a query that searches for customers who placed more than one order within last month, the part checking the orders would be a sub-query since the main query searches for customers.

Note that not all databases support sub-queries.