Re: Complex Select Query

2010-08-25 Thread Ashish Mukherjee
Alternatively, you could just code a recursive function to do the same instead of doing it in SQL or stored procs. On Tue, Aug 24, 2010 at 11:01 AM, Victor Subervi wrote: > On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley > wrote: > > > >What I'm trying to accomplish is to order the results such th

Re: Complex Select Query

2010-08-24 Thread Victor Subervi
On Tue, Aug 24, 2010 at 1:43 PM, Peter Brawley wrote: > >What I'm trying to accomplish is to order the results such that after > >stacking the data for all results for a certain category, that the next > >results to be stacked should be those whose parent = the former category, > >then move on to

Re: Complex Select Query

2010-08-24 Thread Peter Brawley
>What I'm trying to accomplish is to order the results such that after >stacking the data for all results for a certain category, that the next >results to be stacked should be those whose parent = the former category, >then move on to the next category, etc. How do I do this? It's a tree. See ht