WITH RECURSIVE Hier(iID, iPK) AS (SELECT p.iID, p.iID AS iPK FROM mItems p WHERE p.iID IN (SELECT ID FROM gttItemsSelected WHERE TRIM(JobID) = ?{vp_JobID}) UNION ALL SELECT H.iID, p2.iID AS iPK FROM mItems p2 JOIN Hier H on p2.iPID = H.iPK) SELECT ... JOIN Hier ON sBOMIItem.iItemID = Hier.iID ...