probably an easy question

[Phil]

i have a table that contains different cities and states.
an entry might look like this

city state
---------- ------
Minneapolis MN
St Paul MN
.....

and so on. what i would like to do is get all the city names but only get the state once. when i do a group by it only gets one city for each state. should i make a new table that holds the states seprately?

what i would like is this

MN
Minneapolis
St Pul

CA
Los Angeles
San Diego
......
and so on

any help would be great.

thanks