| SELECT sum(shipper_line.all_amt) 总发货金额 , (select sum(user_4) from shipper where datediff(week,trans_date+6,getdate())=0 ) 总发货件数, dateformat(getdate(),'YYYY,MM DD') 截止日, DATEFORMAT(dateadd(dd,-6,getdate()),'YYYY,MM DD') 启始日 FROM "DBA"."shipper" ,shipper_line where shipper.trans_no=shipper_line.trans_no and datediff(week,trans_date+6,getdate())=0 |
