Results 1 to 3 of 3

Thread: ORDER BY

  1. #1
    Join Date
    Dec 1969

    Default ORDER BY

    I am wondering if it is possible to have 2 order by clauses in the same SQL query like so:<BR><BR>SQL = "SELECT * FROM tblWhatever WHERE y =&#039;Yes&#039; ORDER BY dateof DESC AND ORDER BY timeof DESC<BR><BR>My problem is I have 2 fields in the database, 1 called timeof and 1 called dateof. I want to rteturn the results in the most sequential order except I can not combuine the fields in the DB.<BR>Please help....

  2. #2
    Join Date
    Dec 1969

    Default You can

    use order byfield1, field2

  3. #3
    Nathan Masek Guest

    Default Yes You Can ...

    At least they did in thos book I have =]

Posting Permissions

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