I want to find
SUM of Table 1 & Table 2 in Result Table. As shown in the above Result table.
I have tried with the query below
Select Sum(t2.[Lead Score] + t1.[Lead Score]) [Lead Score], t2.SubscriberKey from [Table1] t2 left join [Table2] t1 on t2.SubscriberKey= t1.SubscriberKey group by t2.SubscriberKey