| 1234567891011121314 |
- 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
|
