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

Item Value
SQLCODE -144
Constant SQLE_COLUMN_AMBIGUOUS
SQLSTATE 52002
Sybase error code 209
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 Name of the ambiguous column.

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.