두 테이블 join

템플릿

SELECT A.컬럼명1, A.컬럼명2
            ,  B.컬럼명3, B.컬럼명4
FROM     테이블명1 A, 테이블명2 B
WHERE  A.테이블명1기본키 = B.테이블명2기본키
AND       A.테이블명1기본키 = '검색어'
ORDER BY B.테이블명2
;

예시

SELECT A.COM_CODE, A.COM_CODE_NM
            ,  B.COM_CODE_DETAIL, B.COM_CODE_DETAIL_NM
FROM     COM_CODE A, COM_CODE_DETAIL B
WHERE  A.COM_CODE = B.COM_CODE
AND       A.COM_CODE = 'natn'
ORDER BY B.COM_CODE_DETAIL
;