Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

Column '%1' found in more than one table -- need a correlation name

Error constant SQLE_COLUMN_AMBIGUOUS
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the ambiguous column.
Severity 16
SQLCODE –144
SQLSTATE 52002
Sybase error code 209
Probable cause

You have not put a correlation name on a column that is found in more than one of the tables referenced in a query. You need to add a correlation name to the reference.