{"id":19710,"date":"2010-11-12T00:20:07","date_gmt":"2010-11-12T08:20:07","guid":{"rendered":"https:\/\/edelalon.com\/blog\/?p=19710"},"modified":"2021-07-22T23:11:27","modified_gmt":"2021-07-23T06:11:27","slug":"sql-joins","status":"publish","type":"post","link":"https:\/\/www.edelalon.com\/blog\/sql-joins\/","title":{"rendered":"SQL Joins"},"content":{"rendered":"

I keep forgetting so I’m writing it down here.<\/p>\n

Inner Join<\/h2>\n

Also called Join. This join returns the rows present in both the left table<\/strong> and right table<\/strong> only if there is a match. Otherwise, it returns zero records.<\/p>\n

Full Outer Join<\/h2>\n

Also called as Full Join. This join returns all the rows present in both the left table<\/strong> and the right table<\/strong>.<\/p>\n

Left Outer join<\/h2>\n

Or called as Left Join. This join returns all the rows present in the left table<\/strong> and matching rows from the right table<\/strong>.<\/p>\n

Right Outer Join<\/h2>\n

Also called as Right Join. This join returns matching rows from the left table<\/strong>, and all the rows present in the right table<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

I keep forgetting so I’m writing it down here. Inner Join Also called Join. This join returns the rows present in both the left table and right table only if there is a match. Otherwise, it returns zero records. Full Outer Join Also called as Full Join. This join returns all the rows present in […]<\/p>\n","protected":false},"author":1,"featured_media":19711,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":"","footnotes":""},"categories":[44],"tags":[1080,759],"class_list":["post-19710","post","type-post","status-publish","format-standard","has-post-thumbnail","category-technology","tag-join","tag-sql"],"yoast_head":"\nSQL Joins • Edel Alon<\/title>\n<meta name=\"description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.edelalon.com\/blog\/sql-joins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Joins • Edel Alon\" \/>\n<meta property=\"og:description\" content=\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.edelalon.com\/blog\/sql-joins\/\" \/>\n<meta property=\"og:site_name\" content=\"Edel Alon\" \/>\n<meta property=\"article:published_time\" content=\"2010-11-12T08:20:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T06:11:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1021\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Edel Alon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Edel Alon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/\"},\"author\":{\"name\":\"Edel Alon\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"headline\":\"SQL Joins\",\"datePublished\":\"2010-11-12T08:20:07+00:00\",\"dateModified\":\"2021-07-23T06:11:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/\"},\"wordCount\":118,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/sqljoins.png\",\"keywords\":[\"join\",\"sql\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/\",\"name\":\"SQL Joins • Edel Alon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/sqljoins.png\",\"datePublished\":\"2010-11-12T08:20:07+00:00\",\"dateModified\":\"2021-07-23T06:11:27+00:00\",\"description\":\"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/sqljoins.png\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/sqljoins.png\",\"width\":1021,\"height\":640},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/sql-joins\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Joins\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/\",\"name\":\"Edel Alon\",\"description\":\"Projects, Tools, Craft, Food, Music, and Other Stuff\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/#\\\/schema\\\/person\\\/aaf86bfa75efb59a5f0855c63e330e42\",\"name\":\"Edel Alon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"contentUrl\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\",\"width\":136,\"height\":80,\"caption\":\"Edel Alon\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/edel-alon-logobl.png\"},\"description\":\"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.\",\"sameAs\":[\"https:\\\/\\\/edelalon.com\"],\"url\":\"https:\\\/\\\/www.edelalon.com\\\/blog\\\/author\\\/edelalon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Joins • Edel Alon","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","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:\/\/www.edelalon.com\/blog\/sql-joins\/","og_locale":"en_US","og_type":"article","og_title":"SQL Joins • Edel Alon","og_description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","og_url":"https:\/\/www.edelalon.com\/blog\/sql-joins\/","og_site_name":"Edel Alon","article_published_time":"2010-11-12T08:20:07+00:00","article_modified_time":"2021-07-23T06:11:27+00:00","og_image":[{"width":1021,"height":640,"url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png","type":"image\/png"}],"author":"Edel Alon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Edel Alon","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#article","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/"},"author":{"name":"Edel Alon","@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"headline":"SQL Joins","datePublished":"2010-11-12T08:20:07+00:00","dateModified":"2021-07-23T06:11:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/"},"wordCount":118,"commentCount":0,"publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png","keywords":["join","sql"],"articleSection":["Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.edelalon.com\/blog\/sql-joins\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/","url":"https:\/\/www.edelalon.com\/blog\/sql-joins\/","name":"SQL Joins • Edel Alon","isPartOf":{"@id":"https:\/\/www.edelalon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#primaryimage"},"image":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png","datePublished":"2010-11-12T08:20:07+00:00","dateModified":"2021-07-23T06:11:27+00:00","description":"Hello, we have well thought out reading topics on technology, leadership, project management, food, weddings, and tools to help your daily life. Need some Excel tips or wedding planning advice? Read now and don't forget to comment.","breadcrumb":{"@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.edelalon.com\/blog\/sql-joins\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#primaryimage","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2020\/06\/sqljoins.png","width":1021,"height":640},{"@type":"BreadcrumbList","@id":"https:\/\/www.edelalon.com\/blog\/sql-joins\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.edelalon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Joins"}]},{"@type":"WebSite","@id":"https:\/\/www.edelalon.com\/blog\/#website","url":"https:\/\/www.edelalon.com\/blog\/","name":"Edel Alon","description":"Projects, Tools, Craft, Food, Music, and Other Stuff","publisher":{"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.edelalon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.edelalon.com\/blog\/#\/schema\/person\/aaf86bfa75efb59a5f0855c63e330e42","name":"Edel Alon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","url":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","contentUrl":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png","width":136,"height":80,"caption":"Edel Alon"},"logo":{"@id":"https:\/\/www.edelalon.com\/blog\/wp-content\/uploads\/2017\/09\/edel-alon-logobl.png"},"description":"Edel-Ryan Alon is a starving musician, failed artist, connoisseur of fine foods, aspiring entrepreneur, husband, father of two, geek by day, cook by night, and an all around great guy.","sameAs":["https:\/\/edelalon.com"],"url":"https:\/\/www.edelalon.com\/blog\/author\/edelalon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/19710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/comments?post=19710"}],"version-history":[{"count":0,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/posts\/19710\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media\/19711"}],"wp:attachment":[{"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/media?parent=19710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/categories?post=19710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.edelalon.com\/blog\/wp-json\/wp\/v2\/tags?post=19710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}