{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL'de Outer Join'ler: E\u015fle\u015fmeyen Sat\u0131rlar\u0131 Koruman\u0131n Anahtar\u0131","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"PsVZHY5eZq\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlde-outer-joinler-eslesmeyen-satirlari-korumanin-anahtari\/\">SQL&#8217;de Outer Join&#8217;ler: E\u015fle\u015fmeyen Sat\u0131rlar\u0131 Koruman\u0131n Anahtar\u0131<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlde-outer-joinler-eslesmeyen-satirlari-korumanin-anahtari\/embed\/#?secret=PsVZHY5eZq\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;de Outer Join&#8217;ler: E\u015fle\u015fmeyen Sat\u0131rlar\u0131 Koruman\u0131n Anahtar\u0131&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"PsVZHY5eZq\" 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<\/script>\n","description":"Veritaban\u0131 y\u00f6netim sistemlerinde (DBMS) verileri birle\u015ftirmek i\u00e7in s\u0131k\u00e7a kullan\u0131lan SQL join i\u015flemleri aras\u0131nda, inner join'lerin yan\u0131nda outer join'ler de olduk\u00e7a \u00f6nemlidir. \u00d6zellikle, iki veya daha fazla tablo aras\u0131ndaki ili\u015fkide e\u015fle\u015fmeyen kay\u0131tlar\u0131 da g\u00f6rmek istedi\u011finiz durumlarda outer join'ler vazge\u00e7ilmezdir. Bu yaz\u0131da, SQL'de farkl\u0131 outer join t\u00fcrlerini (LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN) ayr\u0131nt\u0131l\u0131 bir \u015fekilde inceleyece\u011fiz ve bunlar\u0131n kullan\u0131m alanlar\u0131n\u0131 \u00f6rneklerle a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle, temel join kavramlar\u0131n\u0131 hat\u0131rlayal\u0131m. Inner join, sadece iki tablo aras\u0131nda ortak olan sat\u0131rlar\u0131 getirir. Ancak, bir tabloda e\u015fle\u015fmeyen sat\u0131rlar\u0131 da g\u00f6rmek istedi\u011fimiz zaman ise, devreye outer join'ler girer."}