hierarchical query : how to return 'parent' of level 1 + current row ?

From: Vince <vincent.pennec_at_cub-brest.fr>
Date: 14 Nov 2001 03:06:12 -0800
Message-ID: <11d4ca3.0111140306.10c86a63@posting.google.com>

Hi,

Do you know how to return (*) for each row of a hierarchical query PLUS the 'parent' of level 1 ?

eg
grandparent_A

 parent_A_A
  child_A_A_A
  child_A_A_B
 parent_A_B
  child_A_B_A

grandparent_B
 parent_B_A
  child_B_A_A

would return

• for each row + level 1 grandparent_A |...|...|... grandparent_A parent_A_A |...|...|... grandparent_A child_A_A_A |...|...|... grandparent_A ... child_B_A_A |...|...|... grandparent_B

Thanks,

Vincent Pennec Received on Wed Nov 14 2001 - 05:06:12 CST