Select in an hierarchy

Article View: borland.public.vdbase.data.sql

Article #494

Back to borland.public.vdbase.data.sql Previous Next

#494

From: T. L�ubli
Date: Mon, 24 Aug 1998 00:00

18 lines
801 bytes

Hi

How can I select all leaves of a tree which is defined with one table like
this

create table tree
  tree_id
  tree_name
  tree_tree_id
  foreign key tree_tree_id references tree (tree_id)
end

what i am looking for is to select all leaves under a specified leav (more
than one level below the specified leave).

some good ideas? would be great. thank's

Tom

Technical Details

Message-ID: <6rs609$e7f16@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,1846043bf21c8fef,start
X-Google-Attributes: gidff5a1,public
From: "T. L�ubli" <lt@rpag.ch>
Subject: Select in an hierarchy
Date: 1998/08/24
Message-ID: <6rs609$e7f16@forums.borland.com>
X-Deja-AN: 384243578
Organization: Rosenthaler + Partner AG
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql