{"id":479,"date":"2017-03-15T21:40:21","date_gmt":"2017-03-15T19:40:21","guid":{"rendered":"http:\/\/fatihsoysal.com\/blog\/?p=479"},"modified":"2018-03-01T17:04:15","modified_gmt":"2018-03-01T15:04:15","slug":"sql-join-mantigini-kavramak","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/","title":{"rendered":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak"},"content":{"rendered":"<blockquote><p><strong>Merhaba, uzun s\u00fcredir akl\u0131mda b\u00f6yle bir makale yazmak vard\u0131 fakat pek zaman bulamam\u0131\u015ft\u0131m. SQL \u00fczerinde JOIN mant\u0131\u011f\u0131 yeni ba\u015flayan developerlara \u00e7ok\u00e7a karma\u015f\u0131k ve zor gelir. Elimden geldi\u011fince basit bir anlat\u0131m yapmaya \u00e7al\u0131\u015faca\u011f\u0131mdan \u015f\u00fcpheniz olmas\u0131n.<\/strong><\/p><\/blockquote>\n<p><strong>Haydi ba\u015flayal\u0131m!<\/strong><\/p>\n<p><strong>SQL<\/strong> sorgusundaki bir <strong>JOIN<\/strong>, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin iki tabloda olmas\u0131. Yani siz tek tabloda zaten <strong>JOIN<\/strong> kullanmaya gereksinim duymazs\u0131n\u0131z. Bir SQL sorgusu, s\u0131f\u0131r, bir veya birden \u00e7ok JOIN segmenti i\u00e7eriyor olabilir. <strong>INNER JOIN = JOIN<\/strong>&#8216;dir Yani ikisi ayn\u0131 i\u015fleve sahiptir.\u00a0<strong>INNER<\/strong> anahtar kelimesi iste\u011fe ba\u011fl\u0131d\u0131r.<\/p>\n<p><strong>Farkl\u0131 JOIN tiplerine bir g\u00f6z atal\u0131m<\/strong><\/p>\n<p><span style=\"color: #ff0000;\"><strong>(INNER) JOIN:<\/strong><\/span> Her iki tabloda da e\u015fle\u015fen de\u011ferlere sahip kay\u0131tlar\u0131 se\u00e7er.<br \/>\n<span style=\"color: #ff0000;\"><strong>LEFT (OUTER) JOIN:<\/strong><\/span> Do\u011fru tablo kay\u0131tlar\u0131yla e\u015fle\u015fen kay\u0131tlar\u0131 \u00f6nce (soldaki) tablodan se\u00e7er. (Son taraftaki tablo baz al\u0131n\u0131r)<br \/>\n<span style=\"color: #ff0000;\"><strong>RIGHT(OUTER) JOIN:<\/strong><\/span> E\u015fle\u015fen tablo kay\u0131tlar\u0131yla ikinci (sa\u011fdaki) tablodaki kay\u0131tlar\u0131 se\u00e7er.(Sa\u011f taraftaki tablo baz al\u0131n\u0131r)<br \/>\n<span style=\"color: #ff0000;\"><strong>FULL (OUTER) JOIN:<\/strong><\/span> Sol veya sa\u011f tabloda bulunan kay\u0131tlarla e\u015fle\u015fen t\u00fcm kay\u0131tlar\u0131 se\u00e7er.<\/p>\n<p><strong>INNER<\/strong> ve <strong>OUTER<\/strong> anahtar kelimelerinin tamam\u0131yla iste\u011fe ba\u011fl\u0131d\u0131r. JOIN&#8217;ler aras\u0131ndaki farklar\u0131\u00a0a\u015fa\u011f\u0131daki g\u00f6rselde daha iyi anlayacaks\u0131n\u0131z.<\/p>\n<p><center><img fetchpriority=\"high\" decoding=\"async\" class=\" wp-image-482  aligncenter\" src=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/sql-joins.png\" alt=\"sql-joins\" width=\"468\" height=\"340\" srcset=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/sql-joins.png 440w, https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/sql-joins-300x218.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/center><strong>\u015eimdi dilerseniz syntax kullan\u0131mlar\u0131na bakal\u0131m.<\/strong><\/p>\n<p>Genel Kullan\u0131m\u0131:<\/p>\n<pre class=\"lang:default decode:true \">SELECT column-names\r\n  FROM table-name1 JOIN table-name2 \r\n    ON column-name1 = column-name2\r\n WHERE condition<\/pre>\n<p><b>Problem:<\/b>\u00a0M\u00fcd\u00fcr t\u00fcm sat\u0131\u015flar\u0131n m\u00fc\u015fteri kay\u0131tlar\u0131n\u0131 masas\u0131nda istiyor.<\/p>\n<p><b><img decoding=\"async\" class=\" wp-image-494 size-full alignleft\" src=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_1.png\" alt=\"\" width=\"387\" height=\"223\" srcset=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_1.png 387w, https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_1-300x173.png 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/b><\/p>\n<p>\u00d6rne\u011fin yandaki gibi iki ayr\u0131 tablomuz olsun. Problemimiz de yukar\u0131da belirtti\u011fim gibi olsun. Hadi bakal\u0131m!<\/p>\n<p>Nas\u0131l \u00e7\u00f6zece\u011fiz? Art\u0131k ek yapmam\u0131z gereken \u00f6\u011frendiklerimizi uygulamak.<\/p>\n<pre class=\"lang:default decode:true \">SELECT OrderNumber, TotalAmount, FirstName, LastName, City, Country\r\n  FROM [Order] JOIN Customer\r\n    ON [Order].CustomerId = Customer.Id<\/pre>\n<p>Sonu\u00e7 ba\u015far\u0131l\u0131. Tam da istedi\u011fimiz gibi.\u00a0<img decoding=\"async\" class=\"alignnone size-full wp-image-487\" src=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_2.png\" alt=\"Screenshot_2\" width=\"978\" height=\"277\" srcset=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_2.png 978w, https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_2-768x218.png 768w, https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_2-300x85.png 300w, https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/Screenshot_2-800x227.png 800w\" sizes=\"(max-width: 978px) 100vw, 978px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"Merhaba, uzun s\u00fcredir akl\u0131mda b\u00f6yle bir makale yazmak vard\u0131 fakat pek zaman bulamam\u0131\u015ft\u0131m. SQL \u00fczerinde JOIN mant\u0131\u011f\u0131 yeni&hellip;","protected":false},"author":1,"featured_media":481,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[121,10],"tags":[642,143,144,120,141,142],"class_list":{"0":"post-479","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql","8":"category-yazilim","9":"tag-featued","10":"tag-inner-join","11":"tag-let-join","12":"tag-sql","13":"tag-sql-join","14":"tag-sql-oin-mantigi","15":"cs-entry","16":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"description\" content=\"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak\" \/>\n<meta property=\"og:description\" content=\"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-15T19:40:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-01T15:04:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2535\" \/>\n\t<meta property=\"og:image:height\" content=\"1495\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak\",\"datePublished\":\"2017-03-15T19:40:21+00:00\",\"dateModified\":\"2018-03-01T15:04:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\"},\"wordCount\":320,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg\",\"keywords\":[\"featued\",\"inner join\",\"let join\",\"SQL\",\"sql join\",\"sql oin mant\u0131\u011f\u0131\"],\"articleSection\":[\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#respond\"]}],\"copyrightYear\":\"2017\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\",\"name\":\"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg\",\"datePublished\":\"2017-03-15T19:40:21+00:00\",\"dateModified\":\"2018-03-01T15:04:15+00:00\",\"description\":\"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg\",\"width\":2535,\"height\":1495},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","description":"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak","og_description":"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin","og_url":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2017-03-15T19:40:21+00:00","article_modified_time":"2018-03-01T15:04:15+00:00","og_image":[{"width":2535,"height":1495,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg","type":"image\/jpeg"}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak","datePublished":"2017-03-15T19:40:21+00:00","dateModified":"2018-03-01T15:04:15+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/"},"wordCount":320,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg","keywords":["featued","inner join","let join","SQL","sql join","sql oin mant\u0131\u011f\u0131"],"articleSection":["SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#respond"]}],"copyrightYear":"2017","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/","url":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/","name":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg","datePublished":"2017-03-15T19:40:21+00:00","dateModified":"2018-03-01T15:04:15+00:00","description":"SQL sorgusundaki bir JOIN, en basit tabiriyle iki tablodaki kay\u0131tlar\u0131 birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. En \u00f6nemli kural JOIN ilgili olan s\u00fctun de\u011ferlerinin","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/maxresdefault.jpg","width":2535,"height":1495},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sql-join-mantigini-kavramak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Join Mant\u0131\u011f\u0131n\u0131 Kavramak"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=479"}],"version-history":[{"count":18,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/479\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/479\/revisions\/503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/481"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}