Re: SELECT & recursion

Get a copy of TREES & HIERARCHIES IN SQL for single table, relational
models that use only SQL-92. In particular look at the nested sets
model.

.

References:
- SELECT & recursion
  - From: Mike Carroll
- Re: SELECT & recursion
  - From: Mike Carroll

Relevant Pages

Re: Trying to implent (Joe Celkos) Nested Sets, but need more data columns
... Nested sets are just one of many ways to model such ... >things in SQL. ... If anyone using nonrelational features needs help, ... It's possible to model hierarchies to obtain all the benefits of your ...
(microsoft.public.sqlserver.programming)
Re: how to suppress carefully a recursive tree
... Get a copy of TREES & HIERARCHIES IN SQL and look up the Nested Sets ... You can Google it for the basic idea. ...
(comp.databases.theory)
Re: Need Help Spanning A Category Tree
... Get a copy of TREES & HIERARCHIES IN SQL and about the Nested Sets ... It will run much better than this adjacency list model. ...
(comp.databases.ms-sqlserver)
Re: different kind of calculations
... Get a copy of TREES & HIERARCHIES IN SQL and look at the Nested Sets ...
(comp.databases.olap)
Re: Single query to find multi-level relationships?
... get a copy of TREES & HIERARCHIES IN SQL and look at the nested sets ...
(comp.databases)