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