SQL 2003 to 2014 conversion for the operator *=

Question

Please help to convert below query from Sql2003 to 2014, the operator *= does not working, when replace left out join it ignore null rows.

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

"The implicit join syntax has been obsolete since 1992" - https://stackoverflow.com/questions/983862/sql-server-operator — Mitch Wheat, Oct 15 '18 at 05:15

Jacek Wróbel · Accepted Answer · 2018-10-15T05:16:46.347

1

*= operator is deprecated. You should start using ANSI syntax like:

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

edited Oct 15 '18 at 05:16

answered Oct 15 '18 at 04:17

Jacek Wróbel

1,172
10
17

SQL 2003 to 2014 conversion for the operator *=

1 Answers1