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

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

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

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