SELECT A.NODE_ID, A.NODE_TYPE, A.NODE_NAME, A.TURN_P, A.RMRK,  
       A.X_CRDN, A.Y_CRDN, B.TYPE_NM, C.TURN_NM,               
       B.TYPE_NM||'['||A.NODE_TYPE||']' AS NODETYPE,           
       C.TURN_NM||'['||A.TURN_P||']'    AS NODETURN            
  FROM TB_NODE A,                                              
       (SELECT CMMN_CD AS NODE_TYPE, CMMN_CD_KOR_NM AS TYPE_NM 
          FROM TB_CMMN_CD                                      
         WHERE CMMN_CLSF_CD = 'NDT') B,                        
       (SELECT CMMN_CD AS TURN_P, CMMN_CD_KOR_NM AS TURN_NM    
          FROM TB_CMMN_CD                                      
         WHERE CMMN_CLSF_CD = 'TLE') C                         
 WHERE A.NODE_TYPE = B.NODE_TYPE(+)                            
   AND A.TURN_P    = C.TURN_P(+)                               
 ORDER BY A.NODE_ID                                            
