Use Table Aliases

Previous Next

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>