--试试 select a.pcode,a.agntnum,a.zname01,a.zhuname,a.zname03,a.mlagttyp ,sum(a.mlperpp01) as mlperpp01,sum(a.mlperpp04) as mlperpp04 ,sum(a.cntcount01) as cntcount01,sum(IsNull(acctamt,0)) as acctamt from daypf_view as a left join acctamt_view as b on a.agntnum=b.agntnum where a.pcode='785' and a.dtecrt between '20031227' and '20031230' and b.date = '20031230' and b.acctamt>0 group by a.pcode,a.agntnum,a.zname01,a.zhuname,a.zname03,a.mlagttyp order by a.pcode,a.zname03,zhuname,a.agntnum
select a.pcode,a.agntnum,a.zname01,a.zhuname,a.zname03,a.mlagttyp
,sum(a.mlperpp01) as mlperpp01,sum(a.mlperpp04) as mlperpp04
,sum(a.cntcount01) as cntcount01,sum(IsNull(acctamt,0)) as acctamt
from daypf_view as a
left join acctamt_view as b on a.agntnum=b.agntnum
where a.pcode='785' and a.dtecrt between '20031227' and '20031230'
and b.date = '20031230' and b.acctamt>0
group by a.pcode,a.agntnum,a.zname01,a.zhuname,a.zname03,a.mlagttyp
order by a.pcode,a.zname03,zhuname,a.agntnum