日期:2014-05-18 浏览次数:20873 次
select a.djh,a.xm,a.nj,sum(b.fs) fs from a join b on a.djh = b.djh group by a.djh,a.xm,a.nj
------解决方案--------------------
select a.djh,a.xm,a.nj,c.fs from a ,(select djh ,sum(fs) fs from b group by djh) c where a.djh=c.djh