Where does "SORT" go?

Results 1 to 2 of 2

Thread: Where does "SORT" go?

  1. #1
    David Highlander Guest

    Default Where does "SORT" go?

    If I wanted to add "SORT BY PI.clientname" in this statement where do I put it? I can&#039t make it work.<BR><BR> Sqldetails1 = "SELECT AN.clientname, PI.ID, PI.clientname, PI.taskname, PI.taskdetails, " & _<BR> "PI.user, PI.status, PI.itime, PI.idate " & _<BR> "FROM addnew AN, projectinfo PI " & _<BR> "WHERE AN.clientname = PI.clientname "

  2. #2
    Join Date
    Dec 1969

    Default RE: Where does

    Use ORDER BY and put it after the WHERE Clause

Posting Permissions

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