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.