[thelist] SQL Group By question

[Pedro Arana]

no

Make 2 query, frist get groups then the Names



On 12/6/06, Casey Crookston <caseyc at intellisoftmn.com> wrote:
> 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
>
>
>
> Thanks,
>
>
>
> Casey
>
>
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>


-- 
"La forma más rápida de lograr que un ingeniero solucione un problema
es declarar que el problema es insoluble."