CRAZY JOIN

If anyone can help me with this problem I'd really appreciate it and I'll definitely add you to my list of oracle gods.

I have two tables

GROUP_TABLE                          GROUP_SUB_GROUP_TABLE
------------------                 ------------------------
PK GROUP_ID      |-----------------| LEVEL1_ID            |
   DESCRIPTION   |        \        |                      |
   LEVEL         |         \-------| LEVEL2_ID            |
------------------          \      |                      |
                             \-----| LEVEL3_ID            |
                                   ------------------------

I would like a select statement that will print each row in the group_sub_group_table with the description rather than the id

ex:

   president, no_sub, no_sub
   president, vice-pres,no_sub
   president, secr,no_sub
   president, vice-pres, office_sup
   president, vice-pres, administrative_serv
   president, vice-pres, gra

Thanks in advance, David Received on Wed Oct 23 1996 - 00:00:00 CEST