INNER JOIN (±³ÁýÇÕ)
INNER JOIN(NORMAL JOIN)Àº ¿©·¯ Å×À̺íÀÇ Á¶°ÇµéÀÌ ¸ðµÎ ¸¸Á·ÇßÀ»¶§¸¸ µ¥ÀÌŸ¸¦
º¸¿©ÁÖ°Ô µÇ¸ç ÇÑÂÊ Å×À̺íÀÇ Á¶°ÇÀÌ¶óµµ ¸¸Á·ÇÏÁö ¾ÊÀ¸¸é µ¥ÀÌŸ¸¦
º¸¿©ÁÖÁö ¾Ê½À´Ï´Ù.
¿¹) select a.name, b.name from sss as a, bbb as b
where a.code = b.code
¡¡
LEFT OUTER JOIN (±³ÁýÇÕ)
LEFT OUTER JOIN(±³ÁýÇÕ)Àº ¿©·¯ Å×À̺íÀÇ Á¶°ÇµéÀÌ ¸ðµÎ ¸¸Á·ÇÏÁö ¾Ê´õ¶óµµ µ¥ÀÌŸ¸¦
º¸¿©ÁÝ´Ï´Ù.
¿¹) select b.name, c.name from buy as a left
outer join book as b on a.book_code = b.code left
outer join animal as c on a.animal_code = c.code;
¡Ø left outer join ½Ã¿¡´Â ÃÖ´ëÇÑ Áߺ¹°ÇÀÌ ¾È³ª¿Àµµ·Ï À¯ÀÏÇÑ Ä÷³À¸·Î ºñ±³Çؾß
ÇÑ´Ù.
¡Ø left outer join ½Ã¿¡ Á¶°Ç¿¡ ¸¸Á·ÇÏÁö ¾Ê´Â Å×À̺íÀÇ Ä÷³°ªÀº "NULL" ·Î
Ç¥±âµÈ´Ù. |