Error 845

"Owner '%1' used in a qualified column reference does not match correlation name '%2'"

Item Description

SQLCode

-845L

Constant

INVALID_COLUMN_QUALIFICATION

SQLState

42U02

ODBC 2 State

S0002

ODBC 3 State

42S02

Sybase Error Code

2492

Severity Code

15

Parameter 1

The owner name specified in the column reference.

Parameter 2

The correlation name that is incorrectly referenced.

Probable cause

Your query contains a qualified column reference to a table name, but either a correlation name has been used for that table, or the owner of the table does not match the owner name specified in the column reference. Remove the owner qualification, and qualify column references only by correlation name.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com