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
"Simon Wigzell" <si**********@shaw.ca> wrote in message
news:zZ***********************@news2.calgary.shaw. ca...
: 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.
:
: