CREATE VIEW [Order Details Extended] AS 
SELECT OrderID, Products.ProductID as ProductID, ProductName, [Order Details].UnitPrice as UnitPrice, Quantity, Round(Discount,2) as Discount, Round([Order Details].UnitPrice * Quantity * (1 - Discount), 2) AS ExtendedPrice
FROM Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID
ORDER BY OrderID