Not to sound overbearing but the purpose of a correlated subquery is to get the proper row based on information in the same table. Such as a car price table where there are multiple rows for the same vehicle with an effective date for the price.
PF
(On an infant's shirt): Already smarter than Bush