robertjtjones (7/25/2014)
Agree with the above postsI assume that the point is supposed to be that the inner query result affects the rows returned in the outer query - but this answer only seems appropriate for a correlated subquery that is in the WHERE clause of the outer query.
What about when the subquery is in the select clause??
I think it's similar. But the results of the outer query are updated with the results of the repeating inner query instead of being filtrated according to these results.