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