I have an sql statement that currently is just returning all the end parent rows for a list of child rows:

  SELECT DISTINCT row
      FROM table heirarchy
      WHERE parent_row = NULL
    CONNECT BY nocycle PRIOR parent_row = row
     START WITH row IN (select statement returning child rows)

Is there a way to show the child and its corresponding parent together in the same result set using a modified version of my sql?

Thanks.