¡á¿¹ 1_2_18 || ¿¡·¯¹ß»ý ¿¹Á¦_1
SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
T3.ACAD_ABILITY
FROM TABLE_1 T1, TABLE_2 T2, TABLE_3 T3
WHERE T1.SABUN = T2.SABUN(+)
AND T2.ACAD_ABILITY(+) = '´ëÁ¹'
AND T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY(+);
¡á¿¹ 1_2_19 || ¿¡·¯¹ß»ý ¿¹Á¦_2
SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
T3.ACAD_ABILITY
FROM TABLE_1 T1, TABLE_2 T2, TABLE_3 T3
WHERE T1.SABUN = T2.SABUN(+)
AND T2.ACAD_ABILITY(+) = '´ëÁ¹'
AND T2.ACAD_ABILITY(+) = T3.ACAD_ABILITY;
¡á¿¹ 1_2_20 || OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 1
SELECT TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY, TT2.GRAT_YM,
TT3 .GRADE_NUM,
DECODE(TT3.GRADE_NUM, NULL, 100, TT3.GRADE_NUM) AS T_GRADE_NUM
FROM TABLE_2 TT2, TABLE_3 TT3
WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+);
¡á¿¹ 1_2_21 || OUT JOINÀÇ ¿Ã¹Ù¸¥ ¿¹ 2
SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE,
T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YM,
T2.ACAD_ABILITY, T2.GRADE_NUM, T2.T_GRADE_NUM
FROM TABLE_1 T1,
(
SELECT TT2.SABUN, TT2.ACAD_ABILITY, TT2.MAJOR_STUDY,
TT2.GRAT_YM, TT3.GRADE_NUM,
DECODE(TT3.GRADE_NUM,NULL,100,TT3.GRADE_NUM) AS T_GRADE_NUM
FROM TABLE_2 TT2, TABLE_3 TT3
WHERE TT2.ACAD_ABILITY = TT3.ACAD_ABILITY(+)
) T2
WHERE T1.SABUN = T2.SABUN(+);