Column names in expressions

An identifier in an expression.

Syntax
correlation-name.column-name
Remarks

A column name is preceded by an optional correlation name, which typically is the name of a table.

If a column name is a keyword or has characters other than letters, digits and underscore, it must be surrounded by quotation marks (" "). For example, the following are valid column names:

Employees.Name
address
"date hired"
"salary"."date paid"
See also