[thelist] Query Question: Order By, Group By, or Sub Query
Casey Crookston
caseyc at IntelliSoftmn.com
Wed May 31 10:59:53 CDT 2006
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
More information about the thelist
mailing list