• Roland Alexander STL (11/9/2012)


    Maybe, maybe not. Depends on many factors such as indexing, clustering, number of rows in the tables, etc. Check the execution plan to see what's getting processed when. Might surprise you!

    Thanks for the reply

    I want to be able to completely understand what is fundamentally happening here

    The subquery has its results and the outer query has its own results as well, are these 2 results cross referenced?

    Thanks