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 p2.iID, p2.iPID AS iPK FROM mItems p2 JOIN Hier on p2.iPID = Hier.iID) SELECT ... JOIN Hier ON sBOMIItem.iItemID = Hier.iID ...Thanks.