links_TABLE (Parent_id, Child_id, Link_id, ChildType) AS

(

('001', '002', '201', 'Group')

, ('001', '101', '202', 'People')

, ('001', '102', '203', 'People')

, ('002', '003', '204', 'Group')

, ('002', '004', '205', 'Group')

, ('002', '103', '206', 'People')

, ('003', '104', '207', 'People')

, ('004', '105', '208', 'People')

)

, TTEMP (Parent_id, Child_id, Link_id, ChildType, Parent_id_Parent, Link_id_Parent) AS

(

SELECT Parent_id, Child_id, Link_id, ChildType, '000' Parent_id_Parent, '000' Link_id_Parent

FROM links_TABLE C

WHERE NOT EXISTS (SELECT 1 FROM links_TABLE P WHERE P.CHILD_ID = C.PARENT_ID)

UNION ALL

SELECT X.Parent_id, X.Child_id, X.Link_id, X.ChildType, P.Parent_id, P.Link_id

FROM TTEMP P, links_TABLE X

WHERE X.Parent_id = P.Child_id

)

SELECT *

FROM TTEMP;