select t1.*
from sp_tree1(:parent_tree1) tr1
       sp_tree2(:parent_tree2) tr2,
       table1 t1
where (t1.group_id1 = tr1.group_id1) and (t1.group_id2 = tr2.group_id1)

select t1.*
from tmp_tree1 tr1,
       tmp_tree2 tr2,
       table1 t1
where (t1.group_id1 = tr1.group_id) and (t1.group_id2 = tr2.group_id)

CREATE TABLE TREE1 (
    GROUP_ID    INTEGER NOT NULL,
    PARENT         INTEGER,
    NAME  VARCHAR(64),
    SEQUENCE_ID    INTEGER NOT NULL,
    DESCRIPTION    VARCHAR(4096)
);

ALTER TABLE TREE1 ADD CONSTRAINT PK_TREE1 PRIMARY KEY (GROUP_ID);

ALTER TABLE TREE1 ADD CONSTRAINT FK_TREE1 FOREIGN KEY (PARENT) REFERENCES TREE1 (GROUP_ID) ON DELETE CASCADE ON UPDATE CASCADE;

select t1.*
from sp_tree1(:parent_tree1) tr1
       join table1 t1 (t1.group_id1 = tr1.group_id1)
       join sp_tree2(:parent_tree2) tr2 (t1.group_id2 = tr2.group_id1)

select t1.*
from sp_tree1(:parent_tree1) tr1
       join table1 t1 (t1.group_id = tr1.group_id)
PLAN SORT (JOIN (TREE1 INDEX (PK_TREE1), SP_TREE1 NATURAL)(TR INDEX (FK_TREE1))(T1 INDEX (FK_TABLE1)))

select t1.*
from table1 t1
       join sp_tree1(:parent_tree1) tr1 on (t1.group_id = tr1.group_id)

select t1.*
from table1 t1
       join tmp_tree1 tr1 on (t1.group_id = tr1.group_id)

PLAN SORT (JOIN (TR1 NATURAL, T1 INDEX (FK_TABLE1)))

with TBL as (select * from sp_tree1(:parent_tree1))

select tr1.*
from table1 t1
       join tbl tr1 on tr1.group_id=t1.group_id