• Agree with the posts above. It's the "outer" query that determines the execution of the "inner" query.

    The TechNet Link shared (http://technet.microsoft.com/en-us/library/ms187638%28v=sql.105%29.aspx) has sufficient proof for "D" to be the right answer.

    Points, please 🙂

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins