sql order by

Results 1 to 2 of 2

Thread: sql order by

  1. #1
    Join Date
    Dec 1969

    Default sql order by

    hi, i have a really long sql statement with sub sql, i am doing this in the queries part and i have to fields with subsqls, i am not working in design view because access then doesn&#039;t except the full sub sql in the field because it is too long but if i work only in sql view then it works great, now all of these sub sql fields i declare with an &#060;field(sub sql)&#062; as &#060;name&#062;, and i would like to know how can i do order by &#060;name&#062; because if i just do<BR><BR>order by &#060;name&#062;<BR><BR>it askes for a parameter for the name i have chosen.<BR><BR>is there a way i can do order by the first field or something without having to write the first fields name or content?

  2. #2
    Join Date
    Dec 1969

    Default order by 1 <eop>


Posting Permissions

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