|
in regards to the same question. My sql is:
SELECT Orders.OrderID, Customers.LastName, Orders.OrderDate, Products.ProductID, Products.ProductName, [Order Details].Quantity, Products.UnitPrice, [UnitPrice]*[Quantity] AS Amount
FROM Products INNER JOIN ((Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Products.ProductID = [Order Details].ProductID;
My instructions are to:
Create a query called Total Sales by Order, where you display total sales for each order id.
|