{"version":"1.0","provider_name":"sqlity.net","provider_url":"https:\/\/sqlity.net\/en","author_name":"Sebastian Meine","author_url":"https:\/\/sqlity.net\/en\/author\/sebastian\/","title":"A Join A Day \u2013 The Right Outer Join - sqlity.net","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"YnDOphxM1S\"><a href=\"https:\/\/sqlity.net\/en\/1252\/a-join-a-day-the-right-outer-join\/\">A Join A Day \u2013 The Right Outer Join<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/sqlity.net\/en\/1252\/a-join-a-day-the-right-outer-join\/embed\/#?secret=YnDOphxM1S\" width=\"600\" height=\"338\" title=\"&#8220;A Join A Day \u2013 The Right Outer Join&#8221; &#8212; sqlity.net\" data-secret=\"YnDOphxM1S\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/sqlity.net\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"On this sixth day of my A Join A Day series the topic is the right outer join. We are going to compare the right outer to the left outer join and we will see the SQL Server usually avoids them.","thumbnail_url":"http:\/\/sqlity.net\/wp-content\/uploads\/2012\/12\/right-outer-join-example.jpg"}