[thelist] Query Question: Order By, Group By, or Sub Query

[Matt Warden]

On 5/31/06, Casey Crookston <caseyc at intellisoftmn.com> wrote:
> ID         Parent ID           Title
>
> ----------------------------------------------
>
> 1                                  Title1
>
> 2          1                      Title1a
>
> 4          1                      Title1b
>
> 3                                  Title2
>

If I understand your problem correctly:

select *
from mytable
order by Title asc

-- 
Matt Warden
Oxford, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.