Correlated Sub Queries

The sub query runs once for every record in the main query (Like a programming for loop)