The SQL Procedure

column-name

Specifies the column to select.

See also: column-modifier and SELECT Clause

column-name is one of the following:

column

table-name.column

table-alias.column

view-name.column

view-alias.column

Qualifying Column Names
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, 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 */

Chapter Contents
Previous
Next
Top of Page