Before we throw this query into the bug basket, we need to remember a couple of things: 1. Subqueries are not parsed or compiled in ISOLATION from the main (outer) query and cannot therefore be executed in isolation. An independent query plan cannot be generated for them. 2. Subqueries can reference ANY valid columns from sets (tables, Table-valued