■예 1_2_10  || Inner Join의 SQL적용  
SELECT I.SABUN, I.JOIN_GBN_CODE, E.RECT_REG_NO
FROM  INSA I, INSA_EMP_PJT E
WHERE I.SABUN = '2012121201'
   AND I.SABUN =  E.SABUN;

■예 1_2_11  || T1 테이블과 T2 테이블을 Inner Join하여 데이터 조회
--SQL1
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
   T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM   TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN = T2.SABUN;  
 
--SQL2
SELECT   T1.SABUN, NAME, AGE, PHONE,
            T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YM
FROM   TABLE_1 T1 INNER JOIN TABLE_2 T2
   ON   T1.SABUN = T2.SABUN;

■예 1_2_12  || 사원과 참여프로젝트조회
SELECT I.SABUN INSA_SABUN, I.JOIN_GBN_CODE,
         E.SABUN EMP_SABUN, E.RECT_REG_NO
FROM INSA I, INSA_EMP_PJT E
WHERE I.SABUN = E.SABUN(+);

■예 1_2_13  ||  T1 테이블을 기준으로 LEFT OUT JOIN을 이용한 데이터 조회
--SQL1
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
   T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM   TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN = T2.SABUN(+);  
 
--SQL2
SELECT   T1.SABUN, NAME, AGE, PHONE,
            T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YM
FROM   TABLE_1 T1 LEFT OUTER JOIN TABLE_2 T2
   ON   T1.SABUN = T2.SABUN;

■예 1_2_14  ||  T2 테이블을 기준으로 RIGHT OUT JOIN을 이용한 데이터 조회
--SQL1
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
   T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM   TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN(+) = T2.SABUN;  
 
--SQL2
SELECT   T1.SABUN, NAME, AGE, PHONE,
            T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YM
FROM   TABLE_1 T1 RIGHT OUTER JOIN TABLE_2 T2
   ON   T1.SABUN = T2.SABUN;

■예 1_2_15  || T1과 T2 각각의 테이블을 기준으로 FULL OUT JOIN을 이용한 데이터 조회
--SQL1
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
   T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM   TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN = T2.SABUN(+)
UNION
SELECT  T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
   T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM   TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN(+) = T2.SABUN;

--SQL2
SELECT   T1.SABUN, NAME, AGE, PHONE,
            T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YM
FROM   TABLE_1 T1 FULL OUTER JOIN TABLE_2 T2
   ON   T1.SABUN = T2.SABUN;

■예 1_2_16  || OUT JOIN의 잘못된 예
SELECT   T1.SABUN, T1.NAME, T1.AGE, T1.PHONE
           ,T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM  TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN = T2.SABUN(+)
   AND  T2.ACAD_ABILITY = '대졸';

■예 1_2_17  ||  OUT JOIN의 올바른 예
SELECT   T1.SABUN, T1.NAME, T1.AGE, T1.PHONE
           ,T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM
FROM  TABLE_1 T1, TABLE_2 T2
WHERE  T1.SABUN = T2.SABUN(+)
   AND  T2.ACAD_ABILITY(+) = '대졸';