If a column is associated with an explicit table name, the table is searched for the column name. Based on the result of the search, one of the following occurs:
IF this … | IS … | THEN … |
---|---|---|
a matching column | found in the table | the requested information is returned. |
not found in the table | the NAMED list is searched for the column name. “Named” names are not valid when used to fully qualify a table name. |
|
a column name | not found in the explicit table name or in the NAMED list | a nonexistent column error is reported. |