Here's a code sample on how to do it:
WITH cteTable1 AS(
SELECT col1, col2, SUM(col3) sumcol3, SUM(col4) sumcol4
FROM Table1
GROUP BY col1, col2
),
cteTable2 AS(
SELECT col1, col2, SUM(col3) sumcol3, SUM(col4) sumcol4
FROM Table2
GROUP BY col1, col2
)
SELECT *
FROM Table1 AS t1
JOIN Table2 AS t2 ON t1.col1 = t2.col1;