기관정보조회.sql 768 B

123456789101112131415
  1. SELECT A.CNCT_INTN_MNGM_NMBR, A.CNCT_INTN_NM, A.CNCT_INTN_TYPE_CD,
  2. --fn_GetCodeName('COT', A.CNCT_INTN_TYPE_CD) AS CNCT_INTN_TYPE_NM ,
  3. A.CNCT_INTN_TEL, A.CNCT_INTN_ADDR, A.RMRK,
  4. A.FRST_REGR_NMBR, A.FRST_RGST_DT,
  5. A.LAST_CRPR_NMBR, A.LAST_CRCT_DT
  6. FROM TB_CNCT_INTN A
  7. ORDER BY A.CNCT_INTN_MNGM_NMBR
  8. SELECT A.CNCT_INTN_MNGM_NMBR, A.CNCT_INTN_NM, A.CNCT_INTN_TYPE_CD,
  9. A.CNCT_INTN_TEL, A.CNCT_INTN_ADDR, A.RMRK,
  10. A.FRST_REGR_NMBR, A.FRST_RGST_DT,
  11. A.LAST_CRPR_NMBR, A.LAST_CRCT_DT, A.DEL_YN
  12. FROM TB_CNCT_INTN A
  13. ORDER BY A.CNCT_INTN_MNGM_NMBR