You are getting this error because of Collations...
to know more about the collations see:
Technet-Collations[
^] &
Collations[
^]
Quote:
You can specify collations for each character string column using the COLLATE clause of the CREATE TABLE or ALTER TABLE statement. You can also specify a collation when you create a table using SQL Server Management Studio. If you do not specify a collation, the column is assigned the default collation of the database.
so i suggest you to check the collations of the tables you are using in this query, if using any temp tables, specify the collation for the temp table....