160;
T_PRODUCT에lj16; 숫1088;/196; 컬/100;1060; A, B/196; 1648;1221;.104;Ǻ12;1080;lj16;데 1060;,152; T_CLASS, T_CLASSDETAIL1012; 1060;용해서
결과와 같1060; 추출해 내lj16;,172; 목표1077;니다.
컬/100;A/196; 컬/100;C와 INNER JOIN해서 컬/100;Dlj16; 뽑아낼수1080;,192;lj16;데
컬/100;A = 컬/100;E1064; 컬/100;B = 컬/100;F1064; 컬/100;G값1012; 뽑아내기가 도통 쿼린1060;라 쉽1648;않습니다.
ᕬ1;시 Ǻ12;떻,172; Ȣ16;면 1060;,152; 1312;회해낼수1080;1012;까요? 12640;12640;
FROM t_product a
JOIN t_class b ON b.Ä÷³C=a.Ä÷³A
JOIN t_classdetail c ON c.Ä÷³E=a.Ä÷³A AND c.Ä÷³F=a.Ä÷³B
INNER JOINÀ» ±×³É ÇÏ½Ã¸é µË´Ï´Ù.
Á¶ÀÎ Á¶°ÇÀÌ ¸¹À¸¸é ÇØ´ç Á¶°ÇÀ» °è¼Ó ÀûÀ¸¸é µË´Ï´Ù.
from T_PRODUCT, T_CLASSDETAIL, T_CLASS
where Ä÷³A = Ä÷³E
and Ä÷³B = Ä÷³F
and Ä÷³A = Ä÷³C
------------------ outer joinÀÌ ÇÊ¿äÇÏ´Ù¸é, outer join¹® ÀÌ¿ëÇÏ¸é µË´Ï´Ù.
Scalar Sub Query·Îµµ °£´ÜÇÏ°Ô Ã³¸® °¡´ÉÇÏÁö¸¸, LISTµÇ´Â DATA°¡ ÇÑÁ¤µÇ¾îÀÖ°í, list°¡ ÀûÀ»¶§ À¯¸®ÇÕ´Ï´Ù.
select (select Ä÷³D from T_CLASS
where Ä÷³A = Ä÷³C ) as Ä÷³D,
Ä÷³G
from T_PRODUCT, T_CLASSDETAIL
where Ä÷³A = Ä÷³E
and Ä÷³B = Ä÷³F
·Îµµ °£´ÜÈ÷ 󸮰¡´ÉÇÏÁÒ. ¹æ¹ýÀÌ ¸¹¾Æ¿ä.
T_PRODUCT, T_CLASSDETAIL¸¦ subquery·Î ¹°í T_CLASS¶û joinÇصµ µÇ°í,
¹Ý´ë·Î T_PRODUCT, T_CLASS¸¦ subquery·Î ¹°í T_CLASSDETAIL¶û joinÇصµ µË´Ï´Ù. ^^
»ý°¢º¸´Ù ¾öû °£´ÜÇÑ°ÍÀ̾ú±º¿ä...!