SQL$HELP_OLD72.HLB  —  LSE  General SQL Terms, column_name
  column-name =

  ---+----------->-----------------+-> <name-of-column> -->
     +-> <table-name> -------+> . -+
     +-> <view-name> --------+
     +-> <correlation-name> -+

    You can name columns in CREATE TABLE and ALTER TABLE statements.
    In other SQL statements, the names you give to columns can be
    qualified by table name, view names, or aliases.

    The only time you must qualify column names is when they are
    ambiguous. Joining a table with itself and joining two tables
    with common column names are two cases that require qualified
    column names.

    You always have the option of qualifying column names. In complex
    statements, such qualifiers often make the statements more
    readable.
Close Help