1.0Hogart Business Intelligencehttps://businessintelligence.pl/en/hogart.adminhttps://businessintelligence.pl/en/author/hogart-admin/rich600338<blockquote class="wp-embedded-content" data-secret="fBFN63YVDp"><a href="https://businessintelligence.pl/en/slownik/outer-join/">Outer Join</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://businessintelligence.pl/en/slownik/outer-join/embed/#?secret=fBFN63YVDp" width="600" height="338" title="“Outer Join” — Hogart Business Intelligence" data-secret="fBFN63YVDp" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !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); //# sourceURL=https://businessintelligence.pl/wp-includes/js/wp-embed.min.js </script> “Outer join” is a type of join in databases that returns all records when there is a match in at least one of the tables. It is an extension of an inner join, working similarly, but requires an additional specification that does not have to be met in the query. Additionally, you can use LEFT, […]