create table A ( F varchar(10), F1 int )create table B ( id int, D varchar(10), D1 varchar(10) )insert into a values('iv',1) insert into a values('po',3) insert into a values('h',5) insert into a values('v',8)insert into b values(1,'iv','A') insert into b values(2,'po','A') insert into b values(3,'iv','b') insert into b values(4,'h','c') insert into b values(5,'v','A') insert into b values(6,'v','b') insert into b values(7,'po','c')select b.d1,sum(a.f1) from a,b where a.f=b.d group by b.d1
(
F varchar(10),
F1 int
)create table B
(
id int,
D varchar(10),
D1 varchar(10)
)insert into a values('iv',1)
insert into a values('po',3)
insert into a values('h',5)
insert into a values('v',8)insert into b values(1,'iv','A')
insert into b values(2,'po','A')
insert into b values(3,'iv','b')
insert into b values(4,'h','c')
insert into b values(5,'v','A')
insert into b values(6,'v','b')
insert into b values(7,'po','c')select b.d1,sum(a.f1) from a,b
where a.f=b.d
group by b.d1