ITS_OP/VmsOprMain/vms정보제공간 소통정보.sql

SELECT A.VMS_IFSC_ID, A.VMS_IFSC_NM, A.DSPL_STRT_NODE_NM, A.DSPL_END_NODE_NM, A.ROAD_NM, A.SPOT_NM, A.AXIS_YN, A.USE_YN, 
       C.IFSC_ID, C.ORD, E.IFSC_NM, E.STRT_NM, E.END_NM, E.SECT_LNGT,
       B.PRCN_DT, B.SPED, B.TRVL_HH, B.CMTR_GRAD_CD,
       D.PRCN_DT, D.SPED, D.TRVL_HH, D.CMTR_GRAD_CD, D.PTRN_SPED
  FROM TB_VMS_IFSC           A,
       TB_VMS_IFSC_TRAF      B,
       TB_VMS_IFSC_RLTN_IFSC C,
       TB_IFSC_TRAF          D,
       TB_IFSC               E
 WHERE A.VMS_IFSC_ID = B.VMS_IFSC_ID
   AND B.VMS_IFSC_ID = C.VMS_IFSC_ID
   AND C.IFSC_ID     = D.IFSC_ID
   AND D.IFSC_ID     = E.IFSC_ID 
 ORDER BY A.VMS_IFSC_ID, C.ORD