Nesting, grouping Sqlite syntax?
- by Linda
I can't for the life of me figure out this Sqlite syntax.
Our database contains records like:
TX, Austin
OH, Columbus
OH, Columbus
TX, Austin
OH, Cleveland
OH, Dayton
OH, Columbus
TX, Dallas
TX, Houston
TX, Austin
(State-field and a city-field.)
I need output like this:
OH: Columbus, Cleveland, Dayton
TX: Dallas, Houston, Austin
(Each state listed once... and all the cities in that state.)
What would the SELECT statement(s) look like?