Use of Aliases

SQL Server 6.0

If you have aliased the table, you must use the alias throughout the query in place of the table name.

SQL Server 4.2x

If you have aliased the table, you don't need to use the alias throughout the query in place of the table name. This type of a query works like:

select authors.au_lname
from authors auth