运算符 *= 的 SQL 2003 到 2014 转换

Question

请帮助将下面的查询从 Sql2003 转换为 2014，运算符 *= 不起作用，当替换左边连接时，它会忽略空行。

SELECT REJECT_CODE,IsNull(SUM(REJ_M2),0.00) as Rejection 
FROM   dbo.Reject_Code a, dbo.QA_Rej_Det1 b 
WHERE  a.REJ_RKEY *= b.REJ_CODE and b.CUSTOMER_PART_DESC = 'XXXXX'  
GROUP BY REJECT_CODE order by REJECT_CODE

Answer 1

*= 运算符已弃用。您应该开始使用 ANSI 语法，例如：

SELECT REJECT_CODE,IsNull(SUM(REJ_M2),0.00) as Rejection 
FROM   dbo.Reject_Code a 
LEFT OUTER JOIN dbo.QA_Rej_Det1 b 
ON a.REJ_RKEY = b.REJ_CODE AND b.CUSTOMER_PART_DESC = 'XXXXX'  
GROUP BY REJECT_CODE order by REJECT_CODE