correlationName

A correlationName is given to a table expression in a FROM clause as a new name or alias for that table. You cannot qualify a correlationName with a schemaName.

You cannot use correlationNames for updatable columns; using correlationNames in this way will cause an SQL exception. For example:

SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13

In this example, the correlationName col1 FOR c11 is not permitted because c11 is listed in the FOR UPDATE list of columns. You can use the correlationName FOR c12 because it is not in the FOR UPDATE list.

Syntax

SQL92Identifier

Example

-- C is a correlationName
SELECT C.NAME
FROM SAMP.STAFF C