62,046
社区成员
发帖
与我相关
我的任务
分享
SELECT SalesManSysNo ,
SUM(dbo.DO_Master.CashPay) FillPrice ,
SUM(DO_Item.Quantity) FillNumber
FROM dbo.SO_Master Smt
LEFT JOIN dbo.DO_Master ON smt.SysNo = dbo.DO_Master.SOSysNo
LEFT JOIN dbo.DO_Item ON dbo.DO_Master.SysNo = dbo.DO_Item.DOSysNo
WHERE SalesManSysNo = 1
AND dbo.DO_Master.OutTime >= '2011-05-01'
AND dbo.DO_Master.OutTime <= '2011-05-31'
AND dbo.DO_Master.Status = 1
AND SOType=3
GROUP BY SalesManSysNo
LEFT JOIN dbo.DO_Item ON dbo.DO_Master.SysNo = dbo.DO_Item.DOSysNo
????