look at " connect by" sounds like a simple organization chart to me.
Mika Halttu wrote in message <7opf0o$m2l$1_at_baker.cc.tut.fi>...
>Ordering table as a tree
>
>Sample:
>Table sructure
>
>----------
>ID (Counter)
>----------
>Parent (Points to Parents ID)
>----------
>Name (text)
>----------
>Level (Integer)
>----------
>
>Question: Every record can have multiple (or none) "children", every record
>can have only one or none parents. How can I order this table as a tree,
like
>a directory structure, for example?
>
>Mika
>
>--
>--
>Mika Halttu,
>Summer '99: tel. +358-(0)50-5500678 fax. +358-(0)50-85500678
># t. mobile +358 - (0)41 - 5113974
>e-mail: mika.halttu@uta.fi , http://www.uta.fi/~ojmiha/
>Journalism Research Centre, http://www.uta.fi/jourtutkimus/
>Dept. of Journalism and Mass Communication, University of Tampere
>P.O. Box 607, FIN-33101 Tampere, Finland
Received on Tue Aug 10 1999 - 16:07:13 CDT
