"Column '%1' found in more than one table or it is used more than once in the SELECT list -- it needs a correlation name"
Item |
Description |
SQLCode
|
-144L
|
Constant
|
COLUMN_AMBIGUOUS
|
SQLState
|
52002
|
ODBC 2 State
|
37000
|
ODBC 3 State
|
42000
|
Sybase Error Code
|
2084
|
Severity Code
|
16
|
Parameter 1
|
Name of the ambiguous column.
|
Probable cause
You have not specified a correlation name on a column which is found in more than one of the tables referenced in a query block or which appears more than once in the SELECT list of a query block. You need to add a correlation name to the column.