Re: parent/child relationship in the same table.

> before we are getting into this lets return to your question. Is it just plain
> hierarchy that is surfacing once in a while in this thread? For hierarchy you
> have plenty of solutions:
>
> 1. Recursive SQL (SQL 99 standard, implemented in DB2)
> 2. Oracle "connect by"
> 3. Incremental evaluation of transitive closure.

It certainly is a hierarchy problem so probably is a FAQ.

I'm using SQL Server so solutions 1 and 2 are automatically ruled out. Do you have any pointers on number 3?

By the way, is there a FAQ document for the group? A quick search on Google didn't find one.

Thanks,
Jason. Received on Mon Nov 19 2001 - 17:56:52 CET