Post reply

Northwind View Problem

  • April 22, 2003 at 11:49 am

    #160091

    When you run the 'Alphabetical list of products' view the products are not in alphabetical order. here is the code.

    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))

    how could this view be changed so that it lists them correctly?

  • April 22, 2003 at 11:56 am

    #454945

    nevermind, just add

    order by ProductName

    i wonder why that is missing from the view.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply