SELECT PARENTID ID FROM

MERGE INTO MO_DATAGROUP_LINK DGL USING

(

WITH RECURSIVE

CHILDREN AS (

SELECT 923 ID FROM RDB$DATABASE

UNION ALL

SELECT S.ID FROM SPRT S JOIN CHILDREN C ON C.ID = S.PARENTID

),

PARENT_LIST AS (

  SELECT PARENTID ID FROM SPRT WHERE ID = 923

  UNION ALL

  SELECT PARENTID ID FROM SPRT T JOIN PARENT_LIST PT ON T.ID = PT.ID)

SELECT ID FROM PARENT_LIST WHERE ID IS NOT NULL

UNION ALL

SELECT ID FROM CHILDREN

) PX ON DGL.DATAID = PX.ID AND DGL.DATAGROUPID = 896 AND DGL.TABLENAME = 'XXXX'

WHEN NOT MATCHED THEN INSERT (DATAGROUPID, TABLENAME, DATAID) VALUES (:D_VALUE, 'XXXX', PX.ID);