• A correlated subquery looks similar to a regular subquery.
• A regular subquery can be processed from the bottom up.
• For a correlated subquery, the processing is nested, i.e., a row from an upper query statement is used in comparison with rows in a lower-level query.