Define sub-query.

Sub-query is a query within a Query.

Example of sub-query:

Select CustId, Custname From Customer Where Cust_Id IN (Select Doct_Id from Doctor)