{"id":2860,"date":"2024-06-04T15:43:42","date_gmt":"2024-06-04T07:43:42","guid":{"rendered":"https:\/\/itoau.com\/?p=2860"},"modified":"2024-06-04T17:49:08","modified_gmt":"2024-06-04T09:49:08","slug":"sqlserver-join%e8%a1%a8%e8%bf%9e%e6%8e%a5%e7%94%a8%e6%b3%95","status":"publish","type":"post","link":"https:\/\/itoau.com\/?p=2860","title":{"rendered":"SQLServer join\u8868\u8fde\u63a5\u7528\u6cd5"},"content":{"rendered":"<p>SQLServer join\u8868\u8fde\u63a5\u7528\u6cd5<\/p>\n<p>join\u7684\u4f5c\u7528\u4e0d\u7528\u591a\u8bf4\uff0c\u5728\u67e5\u8be2\u6570\u636e\u65f6\u7684\u5e38\u7528\u65b9\u6cd5\u3002join\u901a\u5e38\u6709\u56db\u79cd\u7528\u6cd5\uff0c\u5728\u8fd9\u91cc\u6211\u4eec\u6765\u770b\u4e0b\u6bcf\u79cd\u65b9\u6cd5\u6240\u53d6\u5f97\u7684\u6570\u636e\u7ed3\u679c\u7684\u5dee\u5f02\u3002<\/p>\n<p>\u6a21\u62df\u6570\u636e\u8868A\uff0cB<\/p>\n<p>\u8868A\u6570\u636e\u5185\u5bb9\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2861\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-26-53.jpg\" alt=\"\" width=\"302\" height=\"238\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-26-53.jpg 302w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-26-53-300x236.jpg 300w\" sizes=\"auto, (max-width: 302px) 100vw, 302px\" \/><\/p>\n<p>\u8868B\u6570\u636e\u5185\u5bb9\uff1a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2862\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-27-34.jpg\" alt=\"\" width=\"306\" height=\"238\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-27-34.jpg 306w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-27-34-300x233.jpg 300w\" sizes=\"auto, (max-width: 306px) 100vw, 306px\" \/><\/p>\n<p>\u65b9\u6cd5\u4e00\uff1aleft join<\/p>\n<p>\u8bed\u53e5\uff1aselect * from A <span style=\"color: #ff6600;\">left join<\/span> B on A.id=B.id<\/p>\n<p>\u7ed3\u679c\uff1aA\u4e3a\u57fa\u51c6\u8868\uff0c\u8fde\u63a5B\u8868\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\uff0c\u65e0\u76f8\u7b26\u5185\u5bb9\u5219\u7559\u7a7a<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2863\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-29-07.jpg\" alt=\"\" width=\"353\" height=\"243\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-29-07.jpg 353w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-29-07-300x207.jpg 300w\" sizes=\"auto, (max-width: 353px) 100vw, 353px\" \/><\/p>\n<p>\u65b9\u6cd5\u4e8c\uff1aright join<\/p>\n<p>\u8bed\u53e5\uff1aselect * from A <span style=\"color: #ff6600;\">right join<\/span> B on A.id=B.id<\/p>\n<p>\u7ed3\u679c\uff1aB\u4e3a\u57fa\u51c6\u8868\uff0c\u8fde\u63a5A\u8868\u76f8\u7b26\u7684\u8bb0\u5f55\uff0c\u65e0\u76f8\u7b26\u8bb0\u5f55\u5219\u7559\u7a7a\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2864\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-32-20.jpg\" alt=\"\" width=\"351\" height=\"244\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-32-20.jpg 351w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-32-20-300x209.jpg 300w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/><\/p>\n<p>\u65b9\u6cd5\u4e09\uff1ainner join<\/p>\n<p>\u8bed\u53e5\uff1aselect * from A <span style=\"color: #ff6600;\">inner join<\/span> B on A.id=B.id<\/p>\n<p>\u7ed3\u679c\uff1a\u6ca1\u6709\u57fa\u51c6\u8868\uff0c\u53ea\u53d6A\u3001B\u4e24\u8868\u4e2d\u6761\u4ef6\u76f8\u7b26\u7684\u8bb0\u5f55\uff0c\u4e0d\u76f8\u7b26\u7684\u8bb0\u5f55\u5168\u90e8\u820d\u5f03\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2865\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-35-11.jpg\" alt=\"\" width=\"354\" height=\"173\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-35-11.jpg 354w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-35-11-300x147.jpg 300w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/p>\n<p>\u65b9\u6cd5\u56db\uff1afull outer join<\/p>\n<p>\u8bed\u53e5\uff1aselect * from A <span style=\"color: #ff6600;\">full outer join<\/span> B on A.id=B.id<\/p>\n<p>\u7ed3\u679c\uff1a\u5148\u4ee5A\u8868\u4e3a\u57fa\u51c6\uff0c\u4e14A\u3001B\u4e24\u8868\u6570\u636e\u5168\u90e8\u53d6\u5165\uff0c\u5e76\u6309\u6761\u4ef6\u4f18\u5148\u8fde\u63a5\u6761\u4ef6\u76f8\u7b26\u7684B\u8868\u6570\u636e\uff0c\u65e0\u76f8\u7b26\u7684\u7559\u7a7a\uff0cB\u8868\u4f59\u4e0b\u65e0\u4e3b\u6570\u636e\u653e\u5728\u6700\u540e\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2866\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-39-54.jpg\" alt=\"\" width=\"356\" height=\"312\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-39-54.jpg 356w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-39-54-300x263.jpg 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>\u603b\u7ed3\u56db\u79cd\u65b9\u6cd5\u7684\u7ed3\u679c\u5dee\u5f02<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">A <span style=\"color: #ff6600;\">left join<\/span> B<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2869\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-55-27.jpg\" alt=\"\" width=\"413\" height=\"223\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-55-27.jpg 683w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_15-55-27-300x162.jpg 300w\" sizes=\"auto, (max-width: 413px) 100vw, 413px\" \/><\/p>\n<p><span style=\"color: #000000;\">A <span style=\"color: #ff6600;\">right join<\/span> B<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2870\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-07-01.jpg\" alt=\"\" width=\"412\" height=\"222\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-07-01.jpg 683w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-07-01-300x162.jpg 300w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/><\/p>\n<p>A <span style=\"color: #ff6600;\">inner join<\/span> B<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2871\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-16-37.jpg\" alt=\"\" width=\"382\" height=\"222\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-16-37.jpg 636w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-16-37-300x174.jpg 300w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/p>\n<p>A <span style=\"color: #ff6600;\">full<\/span> <span style=\"color: #ff6600;\">outer join<\/span> B<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2872\" src=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-20-15.jpg\" alt=\"\" width=\"398\" height=\"231\" srcset=\"https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-20-15.jpg 636w, https:\/\/itoau.com\/wp-content\/uploads\/2024\/06\/Snipaste_2024-06-04_16-20-15-300x174.jpg 300w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLServer join\u8868\u8fde\u63a5\u7528\u6cd5 join\u7684\u4f5c\u7528\u4e0d\u7528\u591a\u8bf4\uff0c\u5728\u67e5\u8be2\u6570\u636e\u65f6\u7684\u5e38\u7528\u65b9\u6cd5\u3002join\u901a\u5e38\u6709\u56db\u79cd\u7528\u6cd5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[44],"tags":[],"class_list":["post-2860","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/2860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2860"}],"version-history":[{"count":5,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/2860\/revisions"}],"predecessor-version":[{"id":2879,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/2860\/revisions\/2879"}],"wp:attachment":[{"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}