select S.NumericalOrder, S.Guid, S.WarehouseStockType, S.WarehouseStockAbstract, S.DataDate, S.Number, S.InWarehouseID,WIn.WarehouseName InWarehouseName , 0 IsIn,
S.OutWarehouseID,WOut.WarehouseName OutWarehouseName,S.Remark,
S.EnterpriseID, S.OwnerID, S.CreatedDate, S.ModifiedDate ,
Sum(Detail.Quantity) Quantity
from WM_WarehouseStock S
inner join WM_WarehouseStockDetail Detail on S.NumericalOrder=Detail.NumericalOrder
left join BIZ_Warehouse WIn on S.InWarehouseID=WIn.WarehouseID
left join BIZ_Warehouse WOut on S.OutWarehouseID=WOut.WarehouseID
WHERE S.DataDate between '2016-10-23 10:07:57' and '2016-10-28 10:07:57'
group by S.NumericalOrder, S.Guid, S.WarehouseStockType, S.WarehouseStockAbstract, S.DataDate, S.Number, S.InWarehouseID,WIn.WarehouseName,
S.OutWarehouseID,WOut.WarehouseName,S.Remark,
S.EnterpriseID, S.OwnerID, S.CreatedDate, S.ModifiedDate
order by S.CreatedDate
limit 0,5;