Title: Construct a correlated subquery.
Course: Database Design and Management (Oracle) (10052) > Section: Applying Advanced Data Selection Techniques

Constructing a correlated subquery requires that the inner query execute once for each result returned in the parent query. A correlated subquery will have a JOIN from inner to outer query.