Type this (in AW):
SELECT
(SELECT FROM person.[AddressType] q) from
[HumanResources].Employee
... Now, go to the inner SELECT list, and type "q." ... and you should get a column list from person.AddressType listed first, then a column list from HumanResources.Employee, then every other table ... instead, I'm seeing a column list from HumanResources.Employee first, and the columns from AddressType are all mixed in with every other table in the DB.
SELECT
(SELECT FROM person.[AddressType] q) from
[HumanResources].Employee
... Now, go to the inner SELECT list, and type "q." ... and you should get a column list from person.AddressType listed first, then a column list from HumanResources.Employee, then every other table ... instead, I'm seeing a column list from HumanResources.Employee first, and the columns from AddressType are all mixed in with every other table in the DB.