When joining today 2 tables that originally came from 2 different databases, run into the following error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
The solution happen to be quite simple. Just add the collate keyword in the query.
So, if the original query was
Select q.id1, w.id2
From table1 q
   Inner Join table2 w On q.fld1 = w.fld2 then it will become
Select q.id1, w.id2
From table1 q
   Inner Join table2 w On q.fld1 = w.fld2 Collate SQL_Latin1_General_CP1_CI_AS
Happy coding!