[thelist] SQL Group By question

[Casey Crookston]

> If a table looks like this:
> 
> ID         Name    Group
> 1          NameA Group1
> 2          NameB Group1
> 3          NameC Group2
> 4          NameD Group2
> 
> Is it possible to build a query that would return these results:
> 
> Group1
> NameA
> NameB
> Group2
> NameC
> NameD

>>no, you need program logic for that (or SQL extension from your
database)
maybe with a cube, but its easier to do with programing.<<

Thanks Pedro and everyone else.  I threw these into a couple embedded
data readers and it turned out nicely. 

http://dev.norfire.com/Default.aspx?tabid=84

Thanks!