Ordering tables - more than one sort method

Results 1 to 2 of 2

Thread: Ordering tables - more than one sort method

  1. #1
    Raymond Guest

    Default Ordering tables - more than one sort method

    I am currently sorting a table when opening the database by using<BR>"SELECT * FROM inventory ORDER BY [Category] ASC"<BR><BR>I want it to also sort it by [Product Name] after it is done sorting it by category. How can I do this?<BR><BR>Raymond<BR>Your friendly neighborhood computer programmer.

  2. #2
    Join Date
    Dec 1969
    Posts
    116

    Default RE: Ordering tables - more than one sort method

    you can add things to sort, by separating them with a comma<BR><BR>eg<BR>order by category, productname, blah, blah,<BR><BR>it sorts by the first then the second and so on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •