Qualified column names

A qualifier for a column name can be a table name, a view name, an alias name, or a correlation name.

Whether a column name can be qualified depends on its context:

Where a qualifier is optional it can serve two purposes. See Column name qualifiers to avoid ambiguity and Column name qualifiers in correlated references for details.