求助：请问这样的表怎样连接求合计?(不会太难把)

[filter023]

比如两个表:
riqi bianhao rongliang riqi bianhao jilu
2002-1-1 1 100 2002-1-1 1 10
2002-1-1 1 20


得出：
riqi bianhao rongliang jilu
2002-1-1 1 100 30

[CrazyFor]

select tablea.*,bb.jilu from tableA left outer join bb
(select riqi,max(bianhao) as bianhao,sum(jilu) as jilu from tabel2 group by riqi) BB
on tablea.riqi=bb.riqi

[ccnh]

应该是：
select a.*,sum(b.jilu) as jilu
from table1 a
inner join table2 b on a.riqi=b.riqi and a.bianhao=b.bianhao
group by a.riqi,a.bianhao,a.rongliang

[senzz]

select a.riqi, a.bianhao, a.rongliang, sum(b.jilu) as jilu
from table1 a ,table2 b
where a.riqi=b.riqi and a.bianhao=b.bianhao
group by a.riqi,a.bianhao

[playyuer]

典型的相关子查询!

select * ,
(select sum(jilu)
from T2
where riqi = a.riqi and bianhao = a.bianhao
)
from T1 a

[osfig]

senzz的做法好像不对阿