比如两个表:
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
---------------------------------------------------------------
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
---------------------------------------------------------------
应该是：
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
---------------------------------------------------------------
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
---------------------------------------------------------------
典型的相关子查询!
select * ,
(select sum(jilu)
from T2
where riqi = a.riqi and bianhao = a.bianhao
)
from T1 a