table1 fields:B,sum(A) table2 fields:B,sum(K)
B sum(A) 1 20 2 30 3 40
B sum(k) 5 20 6 70 3 20
SELECT CASE WHEN T1.B IS NULL THEN T2.B ELSE T1.B END AS B, A, K FROM Table_1 AS T1 FULL JOIN Table_2 AS T2 ON T1.B = t2.B
select A.Sum(A),b.Sum(K) from Table1 As A full outer join Table as B on A.B=B.B
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)