[ORACLE]OUT JOIN

SELECT A.POST_ID I_POST_ID,
       A.NAME AS I_NAME,
       A.PHONE1 I_R_PHONE1,
       A.PHONE2 I_R_PHONE2,
       A.PHONE3 I_R_PHONE3,
       NVL (B.GUBUN, '신규') AS GUBUN1,
       A.REGISTER_DT I_REGISTER_DT,
       A.GUBUN GUBUN,
       A.EVENT_YN,
       ROW_NUMBER () OVER (ORDER BY REGISTER_DT DESC) RNM,
       A.CELLPHONE
  FROM EVENT A, APLUS_V_CUSTOMER_CELLPHONE B
AND A.CELLPHONE = B.CELLPHONE(+) AND A.NAME = B.CUSTOMER_NM(+)
ORDER BY A.REGISTER_DT DESC

 

A테이블보다 B테이블이 많을때 OUT JOIN