• 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)