We have created a awesome themeFar far away,behind the word mountains, far from the countries
INFO ½ÇÀü DB¸ðµ¨¸µ°ú SQL°úÁ¤
¡á¿¹ 1_2_10 || Inner JoinÀÇ SQLÀû¿ë SELECT I.SABUN, I.JOIN_GBN_CODE, E.RECT_REG_NOFROM INSA I, INSA_EMP_PJT EWHERE I.SABUN = '2012121201' AND I.SABUN = E.SABUN;
¡á¿¹ 1_2_11 || T1 Å×À̺í°ú T2 Å×À̺íÀ» Inner JoinÇÏ¿© µ¥ÀÌÅÍ Á¶È¸--SQL1SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN = T2.SABUN; --SQL2SELECT T1.SABUN, NAME, AGE, PHONE, T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YMFROM 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_NOFROM INSA I, INSA_EMP_PJT EWHERE I.SABUN = E.SABUN(+);
¡á¿¹ 1_2_13 || T1 Å×À̺íÀ» ±âÁØÀ¸·Î LEFT OUT JOINÀ» ÀÌ¿ëÇÑ µ¥ÀÌÅÍ Á¶È¸--SQL1SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN = T2.SABUN(+); --SQL2SELECT T1.SABUN, NAME, AGE, PHONE, T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YMFROM TABLE_1 T1 LEFT OUTER JOIN TABLE_2 T2 ON T1.SABUN = T2.SABUN;
¡á¿¹ 1_2_14 || T2 Å×À̺íÀ» ±âÁØÀ¸·Î RIGHT OUT JOINÀ» ÀÌ¿ëÇÑ µ¥ÀÌÅÍ Á¶È¸--SQL1SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN(+) = T2.SABUN; --SQL2SELECT T1.SABUN, NAME, AGE, PHONE, T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YMFROM TABLE_1 T1 RIGHT OUTER JOIN TABLE_2 T2 ON T1.SABUN = T2.SABUN;
¡á¿¹ 1_2_15 || T1°ú T2 °¢°¢ÀÇ Å×À̺íÀ» ±âÁØÀ¸·Î FULL OUT JOINÀ» ÀÌ¿ëÇÑ µ¥ÀÌÅÍ Á¶È¸--SQL1SELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN = T2.SABUN(+)UNIONSELECT T1.SABUN, T1.NAME, T1.AGE, T1.PHONE, T2.SABUN, T2.ACAD_ABILITY, T2.MAJOR_STUDY, T2.GRAT_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN(+) = T2.SABUN;
--SQL2SELECT T1.SABUN, NAME, AGE, PHONE, T2.SABUN, ACAD_ABILITY, MAJOR_STUDY, GRAT_YMFROM 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_YMFROM TABLE_1 T1, TABLE_2 T2WHERE 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_YMFROM TABLE_1 T1, TABLE_2 T2WHERE T1.SABUN = T2.SABUN(+) AND T2.ACAD_ABILITY(+) = '´ëÁ¹';