You all getbiggers who know it all about every shit, from politics to who's GH15... What's wrong with this? SELECT EX.EXECUTABLE_ID, REPLACE (C.GENERATED_KEY, {0}, (SELECT GENERATED_ID FROM DP_TARGET_MAP)) FROM DP_COLUMN C, DP_EXECUTABLE EX WHERE EX.EXECUTABLE_ID = C.EXECUTABLE_ID AND C.GENERATED_KEY LIKE '%{0}%' AND EX.DATA_SET_ID = (SELECT EX.EXECUTABLE_ID, EX.NAME, EX.GENERATED_KEY FROM DP_EXECUTABLE EX WHERE EX.DATA_SET_ID = (SELECT DATA_SET_ID FROM DP_DATA_SET DS WHERE DS.DATA_SET = '{2}'))