Northwind
Basic Index Expanded Index
| Field | Type | Nulls? | | ShipName | nvarchar (40) | Yes |
| ShipAddress | nvarchar (60) | Yes |
| ShipCity | nvarchar (15) | Yes |
| ShipRegion | nvarchar (15) | Yes |
| ShipPostalCode | nvarchar (10) | Yes |
| ShipCountry | nvarchar (15) | Yes |
| CustomerID | nchar (5) | Yes |
| CustomerName | nvarchar (40) | No |
| Address | nvarchar (60) | Yes |
| City | nvarchar (15) | Yes |
| Region | nvarchar (15) | Yes |
| PostalCode | nvarchar (10) | Yes |
| Country | nvarchar (15) | Yes |
| Salesperson | nvarchar (31) | No |
| OrderID | int | No |
| OrderDate | datetime | Yes |
| RequiredDate | datetime | Yes |
| ShippedDate | datetime | Yes |
| ShipperName | nvarchar (40) | No |
| ProductID | int | No |
| ProductName | nvarchar (40) | No |
| UnitPrice | money | No |
| Quantity | smallint | No |
| Discount | real | No |
| ExtendedPrice | money | Yes |
| Freight | money | Yes |
create view Invoices AS
SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,
Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City,
Customers.Region, Customers.PostalCode, Customers.Country,
(FirstName + ' ' + LastName) AS Salesperson,
Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName,
"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, Orders.Freight
FROM Shippers INNER JOIN
(Products INNER JOIN
(
(Employees INNER JOIN
(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID)
ON Employees.EmployeeID = Orders.EmployeeID)
INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)
ON Products.ProductID = "Order Details".ProductID)
ON Shippers.ShipperID = Orders.ShipVia