SQL Server 2008 Resolve the collation conflict!
usually when we write a joining query we get this Collation problem. and to fix it, run this query for both the columns being compared
ALTER TABLE [TableName] ALTER COLUMN [ColumnName]
DataType(11)COLLATE Latin1_General_CI_AS NOT NULL