sql左连接时发生字符集异常Cannot resolve the collation conflict between in the equal to operation

sql左连接时发生字符集错误Cannot resolve the collation conflict between in the equal to operation.

SQL语句进行left join的时候发生以下错误：

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" in the equal to operation.

加入database_default就可以了
如
LEFT JOIN @table1 cpt on o.Part = cpt.ProductId COLLATE database_default