8 AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAo9GuKPMDY0aemO4cp96DtgAAAAAIAAAARABUAFMAAAAQZgAAAAEAACAAAAAyFg5oJPZ1ElsANQmDqMNSjVHH4/cCgwmD6DRiMEHikwAAAAAOgAAAAAIAACAAAACG2J5rq29MgOfxkppyBNPq6KBwPiT9nAWzyPzXRUYTqTAAAAB9rCu7jriNcedo/3Zjzb61+AwfZmVp3ok2tIhyPl0unj6zVi9vYhRGWWAbntY6VmNAAAAAtjbtpBPSPELu/enmySzefnUiz6j6t0GEqd+i97Bz/2kj9CxcgMOcbyVSTNGlicNnT+EQHetRqZ7fHxVz2jmFiQ 0 select a.称重时间,a.渠道名称,a.业务员,a.所属客户,a.分公司名称,sum(b.ShippingFee+b.EUTariff+b.AttachFee )运费 from BaseOrderINfo(nolock)a join Finance_Order_Charges(nolock)b on a.系统单号 = b.SystemNo and b.Offset =0 and b.ChargeTarget=1 and a.渠道名称 like '%快线' and a.称重时间 between '2022-08-01' and '2022-09-01' group by a.称重时间,a.渠道名称,a.业务员,a.所属客户,a.分公司名称 936 false 2 0 [BaseETL_KXZB] 936 false 3 false false TABLOCK,CHECK_CONSTRAINTS 2147483647 DataSourceViewID DataSourceViewID TableInfoObjectType Table ]]>