Northwind
Basic Index Expanded Index
| View Name: | Order Details Extended |
| Field | Type | Nulls? | | OrderID | int | No |
| ProductID | int | No |
| ProductName | nvarchar (40) | No |
| UnitPrice | money | No |
| Quantity | smallint | No |
| Discount | real | No |
| ExtendedPrice | money | Yes |
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