dbo.Products by Category | [Back to Details]
    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