dbo.Order Details Extended | [Back to Details]
    create view "Order Details Extended" AS
    SELECT "Order Details".OrderID, "Order Details".ProductID, Products.ProductName,
    	"Order Details".UnitPrice, "Order Details".Quantity, "Order Details".Discount,
    	(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice
    FROM Products INNER JOIN "Order Details" ON Products.ProductID = "Order Details".ProductID
    --ORDER BY "Order Details".OrderID