Sorting Technique required

[bloggerman]

Heres the problem

Sorting has to be done on States(Illinois, California and Florida) based on the number on the side. The cities under the states would show up alphabetically below their respective states. Each is a row in the table of equal weightage and doesn't have any herirachy in place.

Illinois          5
Chicago      10
Peoria         -1
California      4
LA               1
Sandiego      5
SFO             6
Florida         3
Miami           0
Tampa         4

[blom0344]

Doable if you add a relationship between states and their respective cities, otherwise you will a hefty SQL expression to get the result you need