DSRC-RSE 제공구간정보 이력.sql 285 B

123456
  1. SELECT A.OFFR_SECT_ID, A.OFFR_DRCT_NM, A.ID, B.PRE_ID
  2. FROM TB_RSE_OFFR_SECT_MNGM A,
  3. TB_RSE_OFFR_DRCT_INFR B
  4. WHERE A.ID = B.ID
  5. AND A.OBU_ENTR_DRCT_NMBR = B.OBU_ENTR_DRCT_NMBR
  6. ORDER BY TO_NUMBER(OFFR_SECT_ID)