order by then order by

[robsgaming]

is there a way i could first order by video game system, then order by video game title from A-Z

something like

SELECT gametitle FROM games ORDER BY system THEN ORDER BY gametitle

something like that...

[stolzyboy]

SELECT gametitle FROM games ORDER BY system, gametitle

is how you order by two columns

not sure if the order is correct, you may have to switch those around

[robsgaming]

thanks for the reply, it worked!

[stolzyboy]

no problem, remember to mark the thread resolved... if you can't get it to work, lemme know