• Thanks Stuart
    So the subquery becomes (SELECT t1.c1 from t2) which makes even less sense to me!
    I appreciate that t1 is in scope and therefore can be parsed and used, and that MS have documented this behaviour, but I doubt many would find it desirable!