بررسی صحت عملیات :
SELECT OrderByDate.Date, Production.Quantity, Sum(OrderByDate.Quantity) AS SumOfQuantity
FROM OrderByDate INNER JOIN Production ON OrderByDate.Date = Production.Date
GROUP BY OrderByDate.Date, Production.Quantity;
4.PNG
بررسی صحت عملیات :
SELECT OrderByDate.Date, Production.Quantity, Sum(OrderByDate.Quantity) AS SumOfQuantity
FROM OrderByDate INNER JOIN Production ON OrderByDate.Date = Production.Date
GROUP BY OrderByDate.Date, Production.Quantity;
4.PNG