SQL Code for returning parents and children

From: scott felten <sfelten_at_ipsos-asi.com>
Date: 19 Jun 2001 11:49:09 -0700
Message-ID: <56e9c9f0.0106191049.13320607@posting.google.com>

I have a need to query a table and return the parent and its parent and so on... as well as all the children for the row (but no grand children).

I can get to the parents with the following code, but am unable to return the children. Any suggestions?

select question_desc
from adgraph.questionnaire
where job_id = 'TB0101639' start with question_label ='Q1T_BNT' and job_id = 'TB0101639'
connect by question_label = prior parent and job_id = 'TB0101639'

Thanks in advance,

Scott Felten Received on Tue Jun 19 2001 - 13:49:09 CDT