ITS-OP/SRC/PLUGIN/13.TRAFFIC-ANALYSIS-SUPPORT/TAS0040M/패턴정보조회2.sql

SELECT A.ATRD_ID, A.ORD, A.ROAD_ID, B.IFSC_ID, B.ORD
  FROM TB_ATRD_ROAD_RLTN A, TB_ROAD_IFSC_RLTN B
 WHERE A.ROAD_ID = B.ROAD_ID
   AND A.ATRD_ID = 'ATR2001'