SELECT ISNULL(A.NAME,B.NAME) NAME, ISNULL(A.TOTALSERVICE,0)+ISNULL(A.TOTALSALES,0) TOTALSALESSERVICE FROM tablea A FULL JOIN tableb B ON B.NAME=A.NAME