SQL Statement question...

[Mothra]

Can you set two fields to order records by?

 

like this:

 

ORDER BY fldOne ACS, ORDER BY fldTwo Asc

 

or something like that?

[divil]

ORDER BY fldOne, fldTWO DESC

 

etc

[dejota6]

Yes Mothra you can. I have used that in many cases in some of my code. I will include a sample piece of code that I run all the time

 

sql = "Select PR_LNAME, PR_FNAME, PR_MINIT, PR_NUM " _
           & "from IGYPRMSD1 order by PR_LNAME asc, PR_FNAME asc;"

[Nerseus]

I know in SQL Server you can also ORDER BY ordinal position, such as:

SELECT Field1, Field2 FROM Table1
ORDER BY 1 asc, 2 desc -- or is it 0 asc, 1 desc?

 

This comes in handy if you have a complex SELECT, such as a CASE statement or subselect.

 

-ner