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

[Casey Crookston]

Ok, we have a basic table full of navigation links that looks something
like this (greatly simplified):

 

ID         Parent ID           Title

----------------------------------------------

1                                  Title1

2          1                      Title1a

3                                  Title2

4          1                      Title1b

 

 

We want the results to look like this:

 

ID         Parent ID           Title

----------------------------------------------

1                                  Title1

2          1                      Title1a

4          1                      Title1b

3                                  Title2

 

 

Seems simple enough, but I'm at a loss.

 

Thanks!

 

Casey