Re: Recursive queries

2001-03-05 Thread Isaac Force
g of a tree structure is the same, I believe that this is what I have.. (See previous post with table specs. and whatnot) What I'm trying to figure out is an efficient way to go down the tree grabbing information from records that are associated with sections. (Items in a store) I&#x

Re: Recursive queries

2001-03-05 Thread Isaac Force
On Mon, 5 Mar 2001 10:13:29 -0600 "Johnny Withers" <[EMAIL PROTECTED]> wrote: > Well, if you have everything setup right.. this is easy to do in SQL. > > Lets say you have your root table: [...] > > and your sub categories: [...] > > and your final category: [...] > > now you can simply

Recursive queries

2001-03-05 Thread Isaac Force
deep from the root section, so I won't need to find a more effecient way to organize the relationships for now. What do you all feel would be the best way to do this? -- Isaac Force [EMAIL PROTECTED] (503)656-2489 http://gorgonous.dhs.org R