Posted on 2010-08-31
I am using SQL 2005, I have a database with 4 tables.
One table is nsicitem, and one table is ol
When I run this query
left join nsicitem on nsicitem.item = ol.item
I get an error
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN" in the equal to operation.
I checked both tables and they are botl SQL_Latin1_General_CP1_CI_AS
Can some one help me with this please.