是有点问题,改成这样
select a.typeid,b.buildunitid,sum(b.ThisYTotalPlan) as ThisYTotalPlan,
sum(b.ThisYTotal) as ThisYTotal,sum(c.PassTotal) as PassTotal,sum(d.PJPassSum) as PJPassSum
into #Temp4
from baseItems b
left join ItemInvTypes a on a.typeid=b.iteminvtypeid
left join ItemApply c on b.ItemID=c.ItemID
left join MonAccAppro d on b.ItemID=d.ItemID
group by a.typeid,b.buildunitid,c.YearID,c.BatchID,d.YearID,d.BatchID
select a.typeid,b.buildunitid,sum(b.ThisYTotalPlan) as ThisYTotalPlan,
sum(b.ThisYTotal) as ThisYTotal,sum(c.PassTotal) as PassTotal,sum(d.PJPassSum) as PJPassSum
into #Temp4
from baseItems b
left join ItemInvTypes a on a.typeid=b.iteminvtypeid
left join ItemApply c on b.ItemID=c.ItemID
left join MonAccAppro d on b.ItemID=d.ItemID
group by a.typeid,b.buildunitid,c.YearID,c.BatchID,d.YearID,d.BatchID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货