Multi-field database "order by"

[Simon Wigzell]

Is it possible to retrieve data with ASP sorted on 2 fields? I've tried :

SELECT * FROM [TableName] ORDER By Field1 AND Field 2

But it gives an error. I've searched the internet on this topic to no avail.
Is it possible? Thanks.

 

[Ken Schaefer]

ORDER BY Field1, Field2

(will order by Field1, and for items in Field1 that are the same, it will
order by Field2)

Cheers
Ken


: Is it possible to retrieve data with ASP sorted on 2 fields? I've tried :
:
: SELECT * FROM [TableName] ORDER By Field1 AND Field 2
:
: But it gives an error. I've searched the internet on this topic to no
avail.
: Is it possible? Thanks.
:
: