Correlated subqueries run N times, once for each outer row. Your solution (assuming the database supports predicate pushdown) is far better.