You can also put the COLLATE to the column names where you are getting collation error like this:
Column1 Collate collationname = Column2 Collate collationname
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/