Results 1 to 3 of 3

Thread: tables

  1. #1
    Join Date
    Mar 2004
    Posts
    9

    Unanswered: tables

    Hi there. I have a table in my database that contains about 200 rows. Sometimes when I bring up the table the rows change their order. I need this table to come up in a specific order but sometimes the rows change their order. Why is this and how can I correct??
    Sharon))

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    use a query with an ORDER BY
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Or, open the table, put the cursor in the colum you want to sort, press the AZ or ZA button to sort the table according to the selected colum. Save the table, it will stay in this order.

Posting Permissions

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