CREATE VIEW dbo.[Alphabetical list of products]
AS
SELECT     dbo.Products.*, dbo.Categories.CategoryName AS CategoryName
FROM         dbo.Categories INNER JOIN
                      dbo.Products ON dbo.Categories.CategoryID = dbo.Products.CategoryID
WHERE     (dbo.Products.Discontinued = 0)