{"id":8070,"date":"2019-10-20T05:44:16","date_gmt":"2019-10-20T09:44:16","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=8070"},"modified":"2021-12-08T10:56:52","modified_gmt":"2021-12-08T15:56:52","slug":"sql-joins-infographic","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/sql-joins-infographic\/","title":{"rendered":"SQL Joins Infographic"},"content":{"rendered":"\n

Enjoy this free SQL joins infographic illustrating how the different types of joins work. It uses shapes and highlighting to visualize the kind of data you want to retrieve and how the join works each with an example SQL statement.<\/p>\n\n\n\n

Types of joins featured here include left join, right join, inner join, and outer join. The infographic also illustrates the effect of including null in the where clause.<\/p>\n\n\n\n

Download the PDF SQL join infographic here<\/a>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Enjoy this free SQL joins infographic illustrating how the different types of joins work. It uses shapes and highlighting to visualize the kind of data you want to retrieve and…<\/p>\n","protected":false},"author":1,"featured_media":8071,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,11,27,16],"tags":[177,180,393,433,449,543,544,549,550,551],"yoast_head":"\nSQL Joins Infographic Download - Brightwhiz.com<\/title>\n<meta name=\"description\" content=\"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Joins Infographic Download - Brightwhiz.com\" \/>\n<meta property=\"og:description\" content=\"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-20T09:44:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-08T15:56:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2548\" \/>\n\t<meta property=\"og:image:height\" content=\"3298\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\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\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"SQL Joins Infographic\",\"datePublished\":\"2019-10-20T09:44:16+00:00\",\"dateModified\":\"2021-12-08T15:56:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\"},\"wordCount\":78,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png\",\"keywords\":[\"Data\",\"Database\",\"MySQL\",\"Optimization\",\"Performance\",\"Software Design\",\"Software development\",\"SQL\",\"SQL Server\",\"SQLite\"],\"articleSection\":[\"Articles\",\"Infographics\",\"Programming\",\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\",\"url\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\",\"name\":\"SQL Joins Infographic Download - Brightwhiz.com\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png\",\"datePublished\":\"2019-10-20T09:44:16+00:00\",\"dateModified\":\"2021-12-08T15:56:52+00:00\",\"description\":\"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/sql-joins-infographic\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png\",\"width\":2548,\"height\":3298,\"caption\":\"SQL-Joins Infographic\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/sql-joins-infographic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Joins Infographic\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Joins Infographic Download - Brightwhiz.com","description":"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database","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":"http:\/\/local.brightwhiz\/sql-joins-infographic\/","og_locale":"en_US","og_type":"article","og_title":"SQL Joins Infographic Download - Brightwhiz.com","og_description":"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database","og_url":"http:\/\/local.brightwhiz\/sql-joins-infographic\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2019-10-20T09:44:16+00:00","article_modified_time":"2021-12-08T15:56:52+00:00","og_image":[{"width":2548,"height":3298,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png","type":"image\/png"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"SQL Joins Infographic","datePublished":"2019-10-20T09:44:16+00:00","dateModified":"2021-12-08T15:56:52+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/"},"wordCount":78,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png","keywords":["Data","Database","MySQL","Optimization","Performance","Software Design","Software development","SQL","SQL Server","SQLite"],"articleSection":["Articles","Infographics","Programming","Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/","url":"http:\/\/local.brightwhiz\/sql-joins-infographic\/","name":"SQL Joins Infographic Download - Brightwhiz.com","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png","datePublished":"2019-10-20T09:44:16+00:00","dateModified":"2021-12-08T15:56:52+00:00","description":"Download this free SQL joins infographic showing how the likes of inner, outer, left, and right joins work in a mysql database","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/sql-joins-infographic\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2019\/10\/SQL-Joins.png","width":2548,"height":3298,"caption":"SQL-Joins Infographic"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/sql-joins-infographic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"SQL Joins Infographic"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/twitter.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/8070"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=8070"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/8070\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/8071"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=8070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=8070"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=8070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}