I map locations from one table to another by doing something like:
from mytable as p, locationtable as l
However, when I test by:
select mylocation from mytable
where mylocation not in (select location from locationtable)
I got the following error message:
Cannot resolve the collation conflict between "Latin1_General_CS_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
It sounds like two table/columns have different datatype. But not only they are both varchar, I actually map one column from the other. What's the possible problem here? How do I resolve it? Thanks.