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.|