1 2 3 4 5 6 7 8 9 10 | SELECT NVL( ( SELECT MAX (A.INDT) FROM TABLE1_HISTORY A, TABLE1 B, CODE_TABLE C WHERE A.USERID = B.USERID AND A.STATUS = C.CODEID AND A.USERID = ( SELECT DISTINCT USERID FROM TABLE1 D WHERE D.USERID = '사용자ID' AND D.DELETED <> 0 ) AND A.STATUS IN ( 'CODEA' , 'CODEB' , 'CODEC' )) ,( SELECT MAX (UPDT) FROM TABLE1 WHERE USERID = '사용자ID' AND DELETED <>0 ) ) DELETE_DATE FROM DUAL |