Northwind

Basic Index   Expanded Index

View Name:Alphabetical list of products

FieldTypeNulls?
ProductIDintNo
ProductNamenvarchar (40)No
SupplierIDintYes
CategoryIDintYes
QuantityPerUnitnvarchar (20)Yes
UnitPricemoneyYes
UnitsInStocksmallintYes
UnitsOnOrdersmallintYes
ReorderLevelsmallintYes
DiscontinuedbitNo
CategoryNamenvarchar (15)No

create view "Alphabetical list of products" AS
SELECT Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)=0))