{"id":372,"date":"2024-04-22T10:32:40","date_gmt":"2024-04-22T01:32:40","guid":{"rendered":"https:\/\/sejiwon.com\/?p=372"},"modified":"2024-04-22T10:32:40","modified_gmt":"2024-04-22T01:32:40","slug":"%ea%b8%b0%eb%b3%b8%ec%a0%81%ec%9d%b8-table%ea%b0%84%ec%9d%98-join-%ec%9b%90%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=372","title":{"rendered":"\uae30\ubcf8\uc801\uc778 TABLE\uac04\uc758 JOIN \uc6d0\ub9ac"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"536\" src=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-1024x536.png\" alt=\"\" class=\"wp-image-373\" srcset=\"https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-1024x536.png 1024w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-300x157.png 300w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-768x402.png 768w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-1536x804.png 1536w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-2048x1072.png 2048w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-660x346.png 660w, https:\/\/sejiwon.com\/wp-content\/uploads\/2024\/04\/image-4-380x200.png 380w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\uc704 \uadf8\ub9bc\uc744 \ubcf4\uc2dc\uba74\uc11c \uc5ec\ub7ec\ubd84\uc758 \uc0dd\uac01\uc740 \uc5b4\ub5a0\uc2e0\uc9c0\uc694?<\/p>\n\n\n\n<p>\ud639\uc2dc A\ucc98\ub7fc \ud14c\uc774\ube14\ub07c\ub9ac \uc5f0\uacb0\ub41c\ub2e4\uace0 \uc0dd\uac01\ud558\uace0 \uacc4\uc2dc\uc9c0 \uc54a\uc73c\uc168\ub098\uc694?<\/p>\n\n\n\n<p>\ub450 \uac1c\uac00 \ubb50\uac00 \ub2e4\ub974\uc9c0? \ub77c\uace0 \uc0dd\uac01\ud558\uc2e0\ub2e4\uba74 \uc870\uae08\ub9cc \uc0dd\uac01\ud574 \ubcf4\uc2ed\uc2dc\uc624.<\/p>\n\n\n\n<p>\uc660\uc9c0 A\uc758 \uacbd\uc6b0\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c \ud589\uc758 \uac2f\uc218\uac00 \ubcc0\ud654\uc5c6\uc774 \uc5f0\uacb0\ub418\ub294 \uac83\ucc98\ub7fc \ub290\uaef4\uc9c0\uc9c0 \uc54a\uc73c\uc2dc\ub098\uc694?<\/p>\n\n\n\n<p>\uc624\ub978\ucabd B\uc758 \uacbd\uc6b0\ub294 \ud14c\uc774\ube14A,B\uac04\uc5d0 \uc591\ucabd \ub2e4 3\uac74\uc774 \uac01\uac01 9\uac74\uc73c\ub85c \ubc14\ub00c\uc5b4\uc11c \uc11c\ub85c \ub9e4\ud551\ub418\uc5b4 \uc788\ub294 \ubaa8\uc2b5\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \ubaa8\uc2b5\uc744 \ub9ce\uc740 \ubd84\ub4e4\uc774 SQL\uc744 \ubc30\uc6b0\uc2dc\uba74\uc11c A\ub77c\uace0 \uc0dd\uac01\ud558\uc2dc\ub294 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc544\ub9c8 \uacb0\uacfc\uac12\uc774 \ub9e4\ubc88 A\uc758 \ud615\ud0dc\ucc98\ub7fc \ub098\uc640\uc11c \uadf8\ub7f4 \uac70\ub77c\uace0 \uc0dd\uac01\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub7ec\ub098, \uc2e4\uc81c\ub294 B\uc640 \uac19\uc740 \ud615\ud0dc\ub85c \ub370\uc774\ud130\uac00 \uacb0\ud569\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud754\ud788 Cartesian\uc758 \uacf1\uc774\ub77c\uace0 \ud569\ub2c8\ub2e4. \uc67c\ucabd\uc5d0 3\uac74\uc774 \uc788\uace0 \uc624\ub978\ucabd\uc5d0 3\uac74\uc774 \uc788\uc73c\ub2c8, 3*3\uc740 9\uc774\ubbc0\ub85c 9\uac1c\uc758 \uacbd\uc6b0\uc758 \uc218\uac00 \ub098\uc624\uaca0\uc9c0\uc694?<\/p>\n\n\n\n<p>\ud14c\uc774\ube14\uc740 \uc774\ub7f0 \uc2dd\uc73c\ub85c \uacb0\ud569\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>FROM\uc808\uc5d0 \uc774\ub807\uac8c \uacb0\ud569\ud55c \ud6c4\uc5d0 WHERE\uc808\uc5d0 \uc788\ub294 \uc870\uac74\uc73c\ub85c \uc6d0\ud558\ub294 \uc9d1\ud569\uc744 \ub9cc\ub4dc\ub294 \uac83\uc774\ub77c\uace0 \uc774\ud574\ud558\uc2dc\uba74 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc704 \uadf8\ub9bc\uc744 \ubcf4\uc2dc\uba74\uc11c \uc5ec\ub7ec\ubd84\uc758 \uc0dd\uac01\uc740 \uc5b4\ub5a0\uc2e0\uc9c0\uc694? \ud639\uc2dc A\ucc98\ub7fc \ud14c\uc774\ube14\ub07c\ub9ac \uc5f0\uacb0\ub41c\ub2e4\uace0 \uc0dd\uac01\ud558\uace0 \uacc4\uc2dc\uc9c0 \uc54a\uc73c\uc168\ub098\uc694? \ub450 \uac1c\uac00 \ubb50\uac00 \ub2e4\ub974\uc9c0? \ub77c\uace0 \uc0dd\uac01\ud558\uc2e0\ub2e4\uba74 \uc870\uae08\ub9cc \uc0dd\uac01\ud574 \ubcf4\uc2ed\uc2dc\uc624. \uc660\uc9c0 A\uc758 \uacbd\uc6b0\ub294 \ub0b4\ubd80\uc801\uc73c\ub85c \ud589\uc758 \uac2f\uc218\uac00 \ubcc0\ud654\uc5c6\uc774 \uc5f0\uacb0\ub418\ub294 \uac83\ucc98\ub7fc \ub290\uaef4\uc9c0\uc9c0 \uc54a\uc73c\uc2dc\ub098\uc694? \uc624\ub978\ucabd B\uc758 \uacbd\uc6b0\ub294 \ud14c\uc774\ube14A,B\uac04\uc5d0 \uc591\ucabd \ub2e4 3\uac74\uc774 \uac01\uac01 9\uac74\uc73c\ub85c \ubc14\ub00c\uc5b4\uc11c \uc11c\ub85c \ub9e4\ud551\ub418\uc5b4 \uc788\ub294 \ubaa8\uc2b5\uc785\ub2c8\ub2e4. \uc774 \ubaa8\uc2b5\uc744 \ub9ce\uc740 \ubd84\ub4e4\uc774 SQL\uc744 \ubc30\uc6b0\uc2dc\uba74\uc11c A\ub77c\uace0 \uc0dd\uac01\ud558\uc2dc\ub294\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=372\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10,1,8],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/372"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=372"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/372\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/372\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}