Table Column Names (SQL)

column_name ::= [table_name.]column_name

Description:

The column name may be (and must be, if a column duplicity may occur) prefixed with the table name, or with the table alias.

Variances from the norm

The # character may be specified after the variable-length column. This character specifies the length (byte count) of this column. Two expressions separated with a comma in brackets may be specified after a CLOB (not NCLOB) type column - by doing so you select a substring starting on the position set by the first expression (beginning with 0) and with the length set by the second expression. The type of such notation is a string with maximum 255 characters.

Usage in a Query:

SELECT A.name
FROM Companies A
WHERE 10000 < (SELECT SUM(B.value)
              FROM INVOICES B
              WHERE A.number=B.company)