Page 1 of 1

Order By

Posted: Sun Jan 11, 2004 9:44 pm
by Straterra
I have a database with music, most of the time by the same Artist..When I get the data, I get it with

Code: Select all

ORDER BY artist
...But, I would also like to alphabetically get the songs by the artists..could I do a

Code: Select all

ORDER BY artist AND songname
?

Posted: Sun Jan 11, 2004 9:55 pm
by JAM

Code: Select all

order by artist, songname
Simply just add a comma between the fieldnames.