Northwind
Basic Index Expanded Index
| View Name: | Products by Category |
| Field | Type | Nulls? | | CategoryName | nvarchar (15) | No |
| ProductName | nvarchar (40) | No |
| QuantityPerUnit | nvarchar (20) | Yes |
| UnitsInStock | smallint | Yes |
| Discontinued | bit | No |
create view "Products by Category" AS
SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE Products.Discontinued <> 1
--ORDER BY Categories.CategoryName, Products.ProductName