Quite true. It's just that this seemed so counter intuitive.

While I have only been working with MSS for just over a year, I have about 20 years working with RDBS...

Thanks. I guess I just needed a little more patience. I finally found the following:

If a column is referenced in a subquery that does not exist in the table referenced...