CREATE VIEW [Order Details Extended]
AS
SELECT OD.OrderID, OD.ProductID, P.ProductName, OD.UnitPrice, OD.Quantity, OD.Discount,
( CONVERT ( money, ( OD.UnitPrice*Quantity* ( 1-Discount ) /100 ) ) *100 )
AS [Net Amount]
FROM [Order Details] OD
INNER JOIN Products P ON P.ProductID = OD.ProductID