The correlated subquery may be executed many times. It will be run once for each candidate row selected in the outer query.
I believe that Jeff Moden refers to this as RBAR (row by agonizing row).
A nice followup article would be "How to avoid using the Correlated Subquery."