Column '%1' found in more than one table-- need a correlation name
| Item | Value | 
|---|---|
| SQLCode | -144 | 
| Constant | SQLE_COLUMN_AMBIGUOUS | 
| SQLState | 52002 | 
| ODBC State | SJS01 | 
| Parameter 1 | name of the ambiguous column | 
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.