이런 방법은 안되는줄 알았는데 작동이 되서 좀 신기하다. Method SELECT PROJECT.ID, CODE.CODE_NAME, PROJECT.NAME AS TITLE, O.NAME AS GROUPNAME, UI.NAME, (SELECT USER_INFO.NAME AS REGIST_USER_NAME FROM USER_INFO where DELETE_YN = 'N' AND ID = PROJECT.REGIST_USER_ID), PROJECT.EXPLANATION, PROJECT.STATUS_CODE_ID, PROJECT.MANAGE_USER_ID, TO_CHAR(PROJECT.CONTRACT_START_DATE, 'YYYY-MM-DD') AS CONTRACT_START_DATE, TO_CHAR(PROJE..