correlation-Name

A correlation-Name is given to a table expression in a FROM clause as a new name or alias for that table. You do not qualify a correlation-Name with a schema-Name.

Syntax

SQL92Identifier

Example

-- C is a correlation-Name 
SELECT C.NAME
FROM SAMP.STAFF C