ITS_OP/SRC - 스마트교차로 테이블 연계 이전 소스/SQL/소통등급정보조회.sql

SELECT SECT_GRAD_CD,     
       SECT_GRAD_NM      
  FROM TB_SECT_GRAD_CLSF 
 ORDER BY SECT_GRAD_CD    



SELECT * FROM TB_SECT_GRAD_CLSF





SELECT A.SECT_GRAD_CD,
       CMTR_GRAD_CD  , 
       LWST_TRVL_SPED, 
       HGHS_TRVL_SPED, 
       CNGS_GRAD_YN 
  FROM TB_CMTR_GRAD_CLSF A, 
       TB_SECT_GRAD_CLSF B
 WHERE A.SECT_GRAD_CD = B.SECT_GRAD_CD
 ORDER BY SECT_GRAD_CD, CMTR_GRAD_CD