SELECT IFSC_ID           ,
       IFSC_NM           ,
       DRCT_CD           ,
       STRT_NM           ,
       END_NM            ,
       SECT_LNGT         ,
       EXTR_CNCT_SECT_YN ,
       DEL_YN            ,
       RMRK              ,
       F_NODE_ID         ,
       T_NODE_ID         ,
       SECT_GRAD_CD      ,
       AREA_CD           ,
       DECODE( AREA_CD, 'LAT001', 'Y', 'N' ) REGN_YN
  FROM TB_IFSC
 ORDER BY IFSC_ID

-- ¼­ºñ½º¸µÅ© ±¸¼ºÁ¤º¸
SELECT IFSC_ID, LINK_ID, ORD 
  FROM TB_IFSC_LINK_RLTN
ORDER BY IFSC_ID, ORD