select a.*,b.bb from (
select bh,sum(a) as aa from ta group by bh) a
inner join
(select bh,sum(b) as bb from tb group by bh ) b
on a.bh=b.bh
select bh,sum(a) as aa from ta group by bh) a
inner join
(select bh,sum(b) as bb from tb group by bh ) b
on a.bh=b.bh
select a.*,b.bb from (select bh,sum(a) suma from ta group by bh) a,
(select bh,sum(b) sumb from tb group by bh) b
where a.bh=b.bh