Use Table Aliases

See Also

Tip

Use table aliases in SQL Statements.

Background

Whenever SQL statements involve more than one table, use table aliases, and prefix all columns by them. This way the statement is parsed faster.

Example

In general, use SQL statements like the following:

SELECT    T1.Column

FROM    Table1 T1

       ,Table2 T2

WHERE    T1.<Column> = T2.<Column>