OUTER JOIN 과 FUCNTION 을 쓰는 방법..
DB 공통명령어 SELECT A.MN_MDUL_CD ,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('15212', MI_CD_VEHL_CD) AS MI_CD_VEHL_CD ,A.PRDN_PLNT_CD ,Sf_Cd_Val_Nm('15212',A.MDUL_SCN_CD) AS KKK ,A.FIRM_CD ,A.APL_STRT_CDT ,A.APL_FNH_CDT ,B.FIRM_NM FROM HAMA_WVOMMDFM A ,T_DLVG_FIRM_INFO B WHERE A.MN_MDUL_CD = '1' AND A.FIRM_CD = B.PART_FIRM_CD(+) 오라클 전용 명령어.. SELECT A.MN_MDUL_CD ,A.MI_CD_VEHL_CD ||' : '||Sf_Cd_Val_Nm('152..