select a.org,a.baogao from (select produce_pjname as org,ISNULL((select sum(produce_amount) from T_produce b where Produce_type='报告' and b.Produce_pjname=a.Produce_pjname group by a.Produce_pjname),0)) as baogao from T_produce a group by Produce_pjname)
还是报错,哎
追答看不到你的图