I figured that despite of having other common columns , I was only joining on INV_Date and that was the mistake. The following code worked. /*Joining INVMAST & CADV*/
Create Table INCADV.INCADV_01 as
Select a.*
, COALESCE(SUM(b.COUPON_POS_C),0) as COUPON_POS_C
, COALESCE(SUM(b.COUPON_WEB_C),0) AS COUPON_WEB_CFROM INVMAST.INVMAST_01 AS a LEFT JOIN CADV.CADV_01 as b
On a.INV_DATE = b.INV_DATE
and a.BV_LM = b.BV_LM
and a.IN_CH = b.IN_CH
and a.LOCA_CODE = b.LOCA_CODE
and a.LOCA_NAME = b.LOCA_NAME
and a.zone = b.zoneGroup by a.INV_DATE, a.LOCA_CODE, a.LOCA_NAME, a.ZONE, a.BV_LM, a.IN_CH;Quit;
... View more