无法解决"SQL_Latin1_General_CP1_CI_AS“和"Chinese_PRC_CI_AS”在等效操作中的排序冲突。

Question

如果我INNER JOIN tblMachine on b.strMachID = tblMachine.strMachID

出现此错误：

不能解决"SQL_Latin1_General_CP1_CI_AS“和"Chinese_PRC_CI_AS”在相等于操作时的排序冲突。

这个错误意味着什么？这是我的问题。

select distinct b.strCostCentreID ,  b.strPOSOnlineRefNo, strPayTypeCode, b.strRemarks as Agency, tblMachine.strDesc As KName,
     (SUM(b.dblPaidAmt)) as RM   
     From tblCurrTrxMaster as b INNER JOIN tblMachine on b.strMachID = tblMachine.strMachID  
     WHERE  strPaymentMethod = '02' and (b.dtmCreated>='1/23/2020') AND (strTransStatus='01')
     GROUP BY b.strCostCentreID , b.strPOSOnlineRefNo, b.strPayTypeCode, b.strRemarks ,b.strMachID, tblMachine.strDesc

Answer 1

您可以强制使用排序规则。

select distinct b.strCostCentreID ,  b.strPOSOnlineRefNo, strPayTypeCode, b.strRemarks as Agency, tblMachine.strDesc As KName,
     (SUM(b.dblPaidAmt)) as RM   
     From tblCurrTrxMaster as b INNER JOIN tblMachine 
    on b.strMachID  COLLATE SQL_Latin1_General_CP1_CI_AS= tblMachine.strMachID  COLLATE SQL_Latin1_General_CP1_CI_AS
     WHERE  strPaymentMethod = '02' and (b.dtmCreated>='1/23/2020') AND (strTransStatus='01')
     GROUP BY b.strCostCentreID , b.strPOSOnlineRefNo, b.strPayTypeCode, b.strRemarks ,b.strMachID, tblMachine.strDesc