Good morning experts! As I fumble my way around sql I have what I think is a very simple join between a table and a view. Below is my sql statement but when I attempt to run I receive the following error:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
I have zero clue on how to resolve. What am I missing?
select dbo.MasterCostCodeList.Level1, dbo.MasterCostCodeList.Level2, dbo.MasterCostCodeList.Level3, dbo.MasterCostCodeList.Description, dbo.MasterCostCodeList.Active, dbo.CPtoTCP_ImportB.Project,
dbo.CPtoTCP_ImportB.[2nd Level], CPtoTCP_ImportB.[3rd Level], CPtoTCP_ImportB.[Desc], CPtoTCP_ImportB.ORG_ID, CPtoTCP_ImportB.Expr1
inner join dbo.CPtoTCP_ImportB on dbo.MasterCostCodeList.Level3=dbo.CPtoTCP_ImportB.[3rd Level]
where dbo.MasterCostCodeList.Active = '1'
and CPtoTCP_ImportB.Expr1 = 'Y'