{"id":9522,"date":"2024-10-14T17:22:49","date_gmt":"2024-10-14T08:22:49","guid":{"rendered":"https:\/\/www.auctionpro.co.kr\/?p=9522"},"modified":"2025-03-10T18:44:43","modified_gmt":"2025-03-10T09:44:43","slug":"right-outer-join","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=9522","title":{"rendered":"RIGHT OUTER JOIN"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Example<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Table: Customers<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>CustomerID<\/th><th>CustomerName<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Alice<\/td><\/tr><tr><td>2<\/td><td>Bob<\/td><\/tr><tr><td>3<\/td><td>Carol<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Table: Orders<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>OrderID<\/th><th>CustomerID<\/th><th>OrderDate<\/th><\/tr><\/thead><tbody><tr><td>101<\/td><td>1<\/td><td>2024-01-01<\/td><\/tr><tr><td>102<\/td><td>3<\/td><td>2024-02-01<\/td><\/tr><tr><td>103<\/td><td>4<\/td><td>2024-03-01<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">LEFT OUTER JOIN Example:<\/h3>\n\n\n\n<div class=\"wp-block-urvanov-syntax-highlighter-code-block\"><pre class=\"lang:mysql decode:true \" >SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, Orders.OrderDate\nFROM Customers\nLEFT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;\n<\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Result:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>CustomerID<\/th><th>CustomerName<\/th><th>OrderID<\/th><th>OrderDate<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Alice<\/td><td>101<\/td><td>2024-01-01<\/td><\/tr><tr><td>2<\/td><td>Bob<\/td><td>NULL<\/td><td>NULL<\/td><\/tr><tr><td>3<\/td><td>Carol<\/td><td>102<\/td><td>2024-02-01<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Example Table: Customers CustomerID CustomerName 1 Alice 2 Bob 3 Carol Table: Orders OrderID CustomerID OrderDate 101 1 2024-01-01 102 3 2024-02-01 103 4 2024-03-01 <a class=\"mh-excerpt-more\" href=\"https:\/\/www.auctionpro.co.kr\/?p=9522\" title=\"RIGHT OUTER JOIN\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-9522","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9522"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9522\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}