select * from (select T_VillageVet_Base.I_VillageVet_ID as DepartId,T_VillageVet_Base.Name,sum(inrangeamount)as Inrangeamount from T_InKillRangeRegister inner join T_VillageVet_Base on T_InKillRangeRegister.departid =T_VillageVet_Base.I_VillageVet_ID where T_InKillRangeRegister.CreatedAt>='1910-1-1' and T_InKillRangeRegister.CreatedAt<'2200-1-1' group by departid,T_VillageVet_Base.Name,T_VillageVet_Base.I_VillageVet_ID ) as Inrange left join (select derpartId,sum(KillAmount) as KillAmountA,count(KillAmount) as KillCountA  from T_KillQuarItem inner join T_KillQuar on T_KillQuarItem.KillQuarId=T_KillQuar.Id where ProductId=5 and T_KillQuar.CreatedAt >='1910-1-1' and T_KillQuar.CreatedAt<'2200-1-1' group by derpartId ) as killA on Inrange.DepartId =killA.derpartId left join (select derpartId,sum(KillAmount) as KillAmountB,count(KillAmount) as KillCountB  from T_KillQuarItem inner join T_KillQuar on T_KillQuarItem.KillQuarId=T_KillQuar.Id where ProductId=6 and T_KillQuar.CreatedAt >='1910-1-1' and T_KillQuar.CreatedAt<'2200-1-1' group by derpartId ) as killB on Inrange.DepartId =killB.derpartId left join (select DepartId,sum(T_Harmless.amount) as harmlessAmount from T_Harmless inner join T_KillRangeAnimal on T_Harmless.KillRangeAnimalId =T_KillRangeAnimal.InKillRangeRegisterId where state=1 and T_Harmless.TreatDate >='1910-1-1' and T_Harmless.TreatDate<'2200-1-1' group by DepartId) as harmless on Inrange.DepartId =harmless.DepartId left join (select DepartId,sum(T_NopaperOutrange.Amount) as nopaperAmount from T_NopaperOutrange  inner join T_KillRangeAnimal on T_NopaperOutrange.KillRangeAnimalId =T_KillRangeAnimal.InKillRangeRegisterId where T_NopaperOutrange.CreatedAt >='1910-1-1' and T_NopaperOutrange.CreatedAt<'2200-1-1' group by DepartId) as nopaper on Inrange.DepartId =nopaper.DepartId