hierarchical sql queries

From: guerillot g <gg200492_at_club-internet.fr>
Date: Sun, 26 Apr 1998 17:52:41 +0200
Message-ID: <35435848.9E77C371@club-internet.fr>

my question is about hierarchical sql queries:

this is my table structure : str_parent

                                       str_child


datas                                1

           2                          3                          4

   5       6        7           8       9       10             11   12

 13 14    15 16   17 18               19 20     21             22

i 'd like to write sql query to obtain the following result:

column_name    level2         level4
 row1                 2              13
 row2                 2              14
 row3                 2              15
                          2              16
                          2              17
                          2              18
                          3              19
                          3              20
                          3              21
                          4              22

if someone can answer me the sql code !!

gil Received on Sun Apr 26 1998 - 10:52:41 CDT