Is it even possible to refer to a strongly typed SQL table object, even after it was an alias?
For example, the following script displays an exception The multi-part identifier "dbo.MyTable.Col3" could not be bound:
SELECT
*
FROM dbo.MyTable MT
INNER JOIN dbo.AnotherTable AT ON
MT.Col1 = AT.Col2
WHERE
dbo.MyTable.Col3 = 'Foo'
source
share