|
||
0
0
lucebella
ù ¹ø° INNER JOINÀ¸·Î ¹¾î¼ Äõ¸®¸¦ Â¥°í
µÎ ¹ø° LEFT OUTER JOIN À¸·Î SELECT * FROM A LEFT JOIN B ON (A.a_idx = B.a_idx) WHERE 1 = 1 AND A.A_idx IS NULL ¼¼¹ø° SELECT * FROM A LEFT JOIN B ON (A.a_idx = B.a_idx) WHERE 1 = 1 AND B.A_idx IS NULL ¿ä 3Äõ¸®¸¦ WITH Àý·Î ¹¾î¼ ÇϳªÀÇ Äõ¸®·Î ¸¸µé¾î¼ ¾²¸é µÉ¶æ!
2017-11-30
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â |
LEFT OUTER
UNION
RIGHT OUTER
·Î Çغ¸¼¼¿ä
´äº¯°¨»çÇÕ´Ï´Ù. Çѹø ½ÃµµÇغ¸°Ú½À´Ï´Ù.