| | |
|---|
| | | left join [Sys_Dictionary] expiretype on expiretype.DicType='到期时间' and expiretype.MeanValue = oc.Expiretype |
|---|
| | | left join ( select ob.BuyerId,sum(ob.SumPrice) SumPrice,sum(ts.PayedMoney) PayedMoney ,COUNT(*) as shuliang |
|---|
| | | from EC_OrderBasic ob Inner Join EC_OrderExtend as oe On(ob.Keyid=oe.Keyid) Inner Join Pay_TradingSingle as ts On(ob.Keyid = ts.OrderId) |
|---|
| | | left join EC_AwbInfo ea on ob.Keyid = ea.Keyid |
|---|
| | | left join EC_AwbInfo ea on ob.Keyid = ea.Keyid Inner Join OA_CorporateClients occ on ob.BuyerId = occ.Keyid where (occ.WanjieTime IS NULL OR DATEDIFF(DAY,occ.WanjieTime,ob.CreateTime)>=0) |
|---|
| | | |
|---|
| | | group by ob.BuyerId ) ob on oc.Keyid = ob.BuyerId |
|---|
| | | |
|---|
