\nSELECT a.sugang_no
\n ,a.class_no
\n ,a.user_id
\n ,a.user_name
\n ,a.email
\n ,a.apply_as_student
\n ,a.office_address
\n ,b.course_name
\n ,b.lecture_start_date
\n ,b.lecture_end_date
\n ,b.course_name
\n ,c.major
\n ,c.organ
\nFROM (sugang as a LEFT OUTER JOIN sugang_class as b ON a.class_no=b.no)
\n LEFT OUTER JOIN member as c on a.user_id=c.user_id
\n order by a.sugang_no desc limit 5 G;<\/p>\n
\n \uc190\ub2d8 \uc774\uac83\uacfc \ub2e4\ub978\uc810\uc744 \ud568\uaed8 \uc62c\ub824 \uc8fc\uc2dc\uba74 \ub2e4\ub978 \uc0ac\ub78c\ub4e4\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \uc218\ub3c4 \uc788\uaca0\ub124\uc694 \uc774\uac74 \ucc38\uace0\uc0ac\ud56d\uc785\ub2c8\ub2e4.
\n(\uc5ec\uae30\uc11c * \ub294 \uc77c\uc77c\uc774 \ub2e4 \uc4f0\uae30 \uadc0\ucc2e\uc544\uc11c \uc77c\ubd80\ub7ec \ud588\uc74c \uceec\ub7fc\uc740 \uc704\uc640 \uac19\uc74c)<\/p>\n
select a.*, b.*, c.*
\nfrom sugang as a, sugang_class as b, member as c
\nwhere a.class_no = b.no and a.user_id = c.user_id
\norder by a.sugang_no desc limit 5
\n 11\/29 16:45:14 <\/p>\n
\n \uac70\uce5c\ub9c8\ub8e8 \uc9e7\uac8c \ub9d0\ud558\uba74, \uad50\uc9d1\ud569\uacfc \ud569\uc9d1\ud569\uc785\ub2c8\ub2e4.
\ninner join(normal join)\uc740 \ub450 \ud14c\uc774\ube14\uc5d0 \ubaa8\ub450 \uc870\uac74\uc774 \ub9cc\uc871\ud558\ub294 \ud544\ub4dc\ub4e4\ub9cc \ucd94\ub824\uc11c \ubcf4\uc5ec\uc8fc\uac8c \ub418\uc9c0\ub9cc, \ud55c\ucabd\uc5d0\ub77c\ub3c4 \ub370\uc774\ud0c0\uac00 \uc5c6\ub2e4\uba74 \ubcf4\uc5ec\uc9c0\uc9c0 \uc54a\uac8c \ub418\ubbc0\ub85c left outer join \uc744 \uc4f0\uba74, \uc88c\uce21 \ud14c\uc774\ube14\uc5d0\ub9cc \uc874\uc7ac\ud558\ub294 \ub370\uc774\ud0c0\uc77c\ucc0c\ub77c\ub3c4 \ub098\uba38\uc9c0 \uce7c\ub7fc\ub4e4\uc740 \ube44\uc6cc\ub454\ucc44 \ucd9c\ub825\ud574\uc90d\ub2c8\ub2e4.<\/p>\n
\uac04\ub2e8\ud55c \uc608\ub85c, \ucd9c\uc11d \ud14c\uc774\ube14\uc744 \ub9cc\ub4e0\ub2e4 \uac00\uc815\ud558\uba74<\/p>\n
normal join \uc73c\ub85c\ub294, \ud55c\ubc88\ub3c4 \ucd9c\uc11d\ud558\uc9c0 \uc54a\uc740 \ud559\uc0dd\uc740 \ubaa9\ub85d\uc5d0\ub3c4 \ubcf4\uc774\uc9c0 \uc54a\uac8c \ub418\uc9c0\ub9cc, outer join \uc73c\ub85c\ub294 \ubaa8\ub450 \ubcfc \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4. <\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT a.sugang_no ,a.class_no ,a.user_id ,a.user_name ,a.email ,a.apply_as_student ,a.office_address ,b.course_name ,b.lecture_start_date ,b.lecture_end_date ,b.course_name ,c.major ,c.organ FROM (sugang as a LEFT OUTER JOIN sugang_class as b ON a.class_no=b.no) LEFT OUTER JOIN member as c on a.user_id=c.user_id order by a.sugang_no desc limit 5 G; \uc190\ub2d8 \uc774\uac83\uacfc \ub2e4\ub978\uc810\uc744 \ud568\uaed8 \uc62c\ub824 \uc8fc\uc2dc\uba74 \ub2e4\ub978 \uc0ac\ub78c\ub4e4\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \uc218\ub3c4 \uc788\uaca0\ub124\uc694 \uc774\uac74 \ucc38\uace0\uc0ac\ud56d\uc785\ub2c8\ub2e4. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-1372","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1372"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1372\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1372"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1372"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}