In which of the following situations should correlation names be used?
A.
A table referenced in the FROM clause has no indexed column.
B.
The table referenced in the FROM clause has more than 200 columns.
C.
Two or more tables in the FROM clause have identical column names.
D.
The FROM clause contains two or more tables in the SELECT statement.
As a qualifier, a correlation name can be used to avoid ambiguity or to establish a correlated reference.
A correlation name can be defined in the FROM clause of a query and after the name of the target table or view in an UPDATE, MERGE, or DELETE statement.
0
0
The use of a correlation name in the FROM clause also allows the option of specifying a list of column names to be associated with the columns of the result table.
0
0