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;
转载于:https://www.cnblogs.com/eric-gms/p/6003938.html
