Error: Cannot resolve collation conflict for equal to operation.

Array北极雪

Run SQL:
    Select T1.*
    From Premium_New.dbo.BrandCode T1,tb_bl_ProductType T2
    Where T2.DeletedFlag=0
    AND T1.BrandName = T2.ProductTypeName
Occur an error:
   BrandName  nvarchar 50
   ProductTypeName nvarchar 30
我改成一样长度也不行。

服务器: 消息 446，级别 16，状态 9，行 1
Cannot resolve collation conflict for equal to operation.

thanks your help

北极雪

是不是nvarchar类型不能用来做 join 阿
如果要做，有其它的方法吗?

北极雪

I have solved the problem.
Use the format OK.
And t1.BrandName *=t2.ProductTypeName collate database_default