> with ta as

May be "with" is overhead and he just need

select tablea.cola1 as col1, sum(tablea.cola2) as total1,
sum(tableb.colb2) as total2
from tablea full join tableb on tablea.cola1=tableb.colb1

SY, SD.