The SQL Procedure

column-name

Specifies the column to select.

See also:

column-modifier

SELECT Clause

column-name

column-name

is one of the following:

column: is the name of a column.
table-name.column: is the name of a column in the table table-name.
table-alias.column: is the name of a column in the table that is referenced by table-alias.
view-name.column: is the name of a column in the view view-name.
view-alias.column: is the name of a column in the view that is referenced by view-alias.

Details

A column can be referred to by its name alone if it is the only column by that name in all the tables or views listed in the current query-expression. If the same column name exists in more than one table or view in the query-expression, then you must qualify each use of the column name by prefixing a reference to the table that contains it. Consider the following examples:

SALARY       /* name of the column */
EMP.SALARY   /* EMP is the table or view name */
E.SALARY     /* E is an alias for the table
                or view that contains the 
                SALARY column */

Top of Page