I tried
SELECT OrderDetails.ProductID as ProductName, OrderDetails.Quantity, Orders.OrderID AS OrderNumber, Orders.OrderDate, Products.Price
FROM ((OrderDetails
INNER JOIN Orders ON OrderDetails.OrderID = Orders.OrderID)
INNER JOIN Products ON OrderDetails.PriceID = Products.Price);
But I'm getting the error "No value given for one or more required parameters". How can I join Products so I can get the price and multiply it by quantity?