I would like to select, not just the 'CYCL_FOLD.CF_FATHER_ID' id, but its name. SELECT RUN.RN_RUN_ID, RUN.RN_EXECUTION_DATE, RUN.RN_EXECUTION_TIME, RUN.RN_PC_VUSERS_INVOLVED, RUN.RN_DURATION, --RUN.RN_CYCLE_ID, CYCLE.CY_FOLDER_ID, CYCLE.CY_CYCLE, CYCL_FOLD.CF_ITEM_NAME, --the folders name CYCL_FOLD....