You haven't read it carefully. It says: "If a table name is aliased, only the alias name can be used to qualify its columns in the ORDER BY clause."
So this will not work:
select a from test t
order by test.a
_______________________________________________
www.sql-kefalo.net (SQL Server saveti, ideje, fazoni i fore)