{"id":12395,"date":"2020-02-23T12:44:26","date_gmt":"2020-02-23T20:44:26","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12395"},"modified":"2023-12-01T02:29:51","modified_gmt":"2023-12-01T10:29:51","slug":"sql-outer-join","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/","title":{"rendered":"SQL Outer Join"},"content":{"rendered":"\n<p>When you\u2019re working with a database, you may want to query two or more tables at the same time and create a combined set of results. For example, you may want to find out the names of every employee and the department for which they work, where those two pieces of information are stored in two different tables.<\/p>\n\n\n\n<p>That\u2019s where <code>SQL<\/code> joins come in. When you join tables, you can run a query across multiple tables and create a combined result.<\/p>\n\n\n\n<p>In this guide, we are going to focus on one type of join: the <code>OUTER JOIN<\/code>. <code>OUTER JOIN<\/code> operators return rows even if they do not have related rows in the final table. We\u2019ll discuss the three types of <code>OUTER JOIN<\/code>s, how they work, and how you can use them in your <code>SQL<\/code> queries.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Joins Refresher<\/h2>\n\n\n\n<p>Queries, which usually begin with the <code>SELECT<\/code> statement, are used to retrieve information from a database. Usually, when you are writing a query you will focus on retrieving information from one table and use the <code>FROM<\/code> clause to specify what table your command will query. Here is the syntax for writing a standard <code>SQL<\/code> query:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT column_name FROM table_name WHERE certain_conditions_are_met;<\/pre><\/div>\n\n\n\n<p>Here\u2019s an example of a query that will retrieve a list of the names of every employee in the <code>employees<\/code> table:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT name FROM employees;<\/pre><\/div>\n\n\n\n<p>Our query returns the following:<\/p>\n\n\n\n<figure class=\"wp-block-table course-info-table\"><table><tbody><tr><td>name<\/td><\/tr><tr><td>Luke<br>Mike<br>Hannah<br>Geoff<br>Alexis<br>Emma<br>Jonah<br>Adam<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(8 rows)<\/p>\n\n\n\n<p>We could also use the <code>WHERE<\/code> clause to filter out the results of our query to include only records that meet a certain set of criteria. For example, we could write a query that finds the names of all sales associates or all executive staff.<\/p>\n\n\n\n<p>But what if we want to get information from multiple tables, and combine the result into one table? That\u2019s where joins come in.<\/p>\n\n\n\n<p>Joins allow you to query multiple tables and create a combined result set with the matched rows. There are three main types of joins: <code>INNER JOIN<\/code>, <code>OUTER JOIN<\/code>, and <code>CROSS JOIN<\/code>.<\/p>\n\n\n\n<p><code>INNER JOIN<\/code>s return rows that have a match in both the tables you are querying, whereas <code>OUTER JOIN<\/code>s return rows even if they don\u2019t have related rows in the joined table. <code>CROSS JOIN<\/code>s are joins without a join condition, and each row of a table is combined with the corresponding row of another table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Outer Joins<\/h2>\n\n\n\n<p>As we have discussed, when you are performing an <code>INNER JOIN<\/code>, rows from either table that are unmatched in another table will not be returned in the results set. But what if we wanted to get these values? We can use the <code>OUTER JOIN<\/code> to retrieve this data.<\/p>\n\n\n\n<p>There are three types of <code>OUTER JOIN<\/code>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>LEFT OUTER JOINS<\/code> return unmatched rows from the left table;<\/li>\n\n\n\n<li><code>RIGHT OUTER JOINS<\/code> return unmatched rows from the right table;<\/li>\n\n\n\n<li><code>FULL OUTER JOINS<\/code> return unmatched rows from all tables.<\/li>\n<\/ul>\n\n\n\n<p><code>OUTER JOIN<\/code>s are capable of matching records from both tables based on our needs and will return all records relevant to the type of join that we use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Joins: Left<\/h2>\n\n\n\n<p>Left joins return all rows from the left table and rows from the right table where the join condition is met.<\/p>\n\n\n\n<p>Let\u2019s say that we have two tables: <code>employees<\/code> and <code>company_departments<\/code>. Now suppose that we wanted to get the name of every employee as well as their department names, even if they are not assigned to any department. We could get this information by using a <code>LEFT JOIN<\/code>.<\/p>\n\n\n\n<p>Below is an example of a <code>LEFT JOIN<\/code> query that will retrieve the name of every employee and their department name by combining the employees and company_departments tables together using their common value: department_id.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT employees.name, company_departments.name\nFROM employees\nLEFT JOIN company_departments\nON employees.department_id = company_departments.department_id;<\/pre><\/div>\n\n\n\n<p>Our query returns the following:<\/p>\n\n\n\n<figure class=\"wp-block-table course-info-table\"><table><tbody><tr><td>name<\/td><td>name<\/td><\/tr><tr><td>Luke<\/td><td>Sales<\/td><\/tr><tr><td>Mike<\/td><td>Sales<\/td><\/tr><tr><td>Hannah<\/td><td>Sales<\/td><\/tr><tr><td>Geoff<\/td><td>Sales<\/td><\/tr><tr><td>Alexis<\/td><td>Sales<\/td><\/tr><tr><td>Emma<\/td><td>Marketing<\/td><\/tr><tr><td>Jonah<\/td><td>Executive<\/td><\/tr><tr><td>Adam<\/td><td><br><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(8 rows)<\/p>\n\n\n\n<p>As you can see, the <code>LEFT JOIN<\/code> has returned all rows from the <code>employees<\/code> table, even if the department for which they work cannot be found in the <code>company_departments<\/code> table.<\/p>\n\n\n\n<p>If you want to learn more about left joins, you can read the Career Karma tutorial on the <code>SQL<\/code> operation here.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Joins: Right<\/h2>\n\n\n\n<p>The <code>RIGHT JOIN<\/code> statement is the direct opposite of the <code>LEFT JOIN<\/code> operator. <code>RIGHT JOIN<\/code> returns all rows from the right table as well as rows from the left table where the join condition is met.<\/p>\n\n\n\n<p>Let\u2019s say that we want to get a list of the names of all departments as well as the names of every employee who works in those departments. And we also want to get data for departments where no employees are assigned. We could use the following query to get this data:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT employees.name, company_departments.name AS \"DeptName\"\nFROM employees\nRIGHT JOIN company_departments\nON employees.department_id = company_departments.department_id;<\/pre><\/div>\n\n\n\n<p>The above query returns the following:<\/p>\n\n\n\n<figure class=\"wp-block-table course-info-table\"><table><tbody><tr><td>name<\/td><td>\u201cdeptname\u201d<\/td><\/tr><tr><td>Luke<\/td><td>Sales<\/td><\/tr><tr><td>Mike<\/td><td>Sales<\/td><\/tr><tr><td>Hannah<\/td><td>Sales<\/td><\/tr><tr><td>Geoff<\/td><td>Sales<\/td><\/tr><tr><td>Alexis<\/td><td>Sales<\/td><\/tr><tr><td>Emma<\/td><td>Marketing<\/td><\/tr><tr><td>Jonah<\/td><td>Executive<\/td><\/tr><tr><td><br><\/td><td>Payroll<\/td><\/tr><tr><td><br><\/td><td>Information Technology<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(9 rows)<\/p>\n\n\n\n<p>As you can see, our query has returned a list of all departments, as well as the names of every employee who works for those departments. The query has also returned the departments <code>Payroll<\/code> and <code>Information Technology<\/code>, which currently have no staff.<\/p>\n\n\n\n<p>In addition, our query did not return Adam, who was the employee from our <code>LEFT JOIN<\/code> query who was not assigned to any department. This is because the <code>RIGHT JOIN<\/code> includes all rows from the right table\u2014company_departments\u2014where our conditions are met, and Adam does not have any affiliation to any record in the right table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Full SQL Outer Joins<\/h2>\n\n\n\n<p><code>Full OUTER JOIN<\/code>s are an uncommon type of <code>SQL join<\/code> that can be used to return unmatched records from both tables. Often, <code>full OUTER JOIN<\/code>s are used with aggregate functions to understand how much overlap exists between two tables.<\/p>\n\n\n\n<p>Let\u2019s say that we want to get a list of all employees and departments. We could use the following <code>SQL<\/code> query to retrieve that information:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT employees.name, company_departments.name AS \"DeptName\"\nFROM employees\nFULL OUTER JOIN company_departments\nON employees.department_id = company_departments.department_id;<\/pre><\/div>\n\n\n\n<p>Our query returns the following:<\/p>\n\n\n\n<figure class=\"wp-block-table course-info-table\"><table><tbody><tr><td>name<\/td><td>\u201cdeptname\u201d<\/td><\/tr><tr><td>Luke<\/td><td>Sales<\/td><\/tr><tr><td>Mike<\/td><td>Sales<\/td><\/tr><tr><td>Hannah<\/td><td>Sales<\/td><\/tr><tr><td>Geoff<\/td><td>Sales<\/td><\/tr><tr><td>Alexis<\/td><td>Sales<\/td><\/tr><tr><td>Emma<\/td><td>Marketing<\/td><\/tr><tr><td>Jonah<\/td><td>Executive<\/td><\/tr><tr><td>Adam<\/td><td><br><\/td><\/tr><tr><td><br><\/td><td>Payroll<\/td><\/tr><tr><td><br><\/td><td>Information Technology<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>(10 rows)<\/p>\n\n\n\n<p>The above result set includes a list of every employee\u2019s name, as well as the department they are assigned to, even if they are not assigned to a department. The result set also includes a list of all department names, even if a department has no employees assigned to it.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p><code>Joins<\/code> are an <code>SQL<\/code> server function that allow you to query two or more tables at the same time and create a combined result set. For example, if you wanted to get a list of company employees, as well as the date their most recent payroll check was processed, you could use a <code>join<\/code>.<\/p>\n\n\n\n<p>In this tutorial, we focused on <code>OUTER JOIN<\/code>s, which return the rows in a <code>join<\/code> even if they don\u2019t have related rows in the joined table. We also discussed the three main types of <code>OUTER JOIN<\/code>s\u2014<code>LEFT JOIN<\/code>, <code>RIGHT JOIN<\/code>, and <code>full OUTER JOIN<\/code>\u2014and explored how they work in practice.<\/p>\n\n\n\n<p>Now you\u2019re ready to perform <code>SQL JOIN<\/code> operations like an expert!<\/p>\n","protected":false},"excerpt":{"rendered":"When you\u2019re working with a database, you may want to query two or more tables at the same time and create a combined set of results. For example, you may want to find out the names of every employee and the department for which they work, where those two pieces of information are stored in&hellip;","protected":false},"author":240,"featured_media":12396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-12395","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":"","is_sponser_post":"","is_guest_post":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v27.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Outer Join: A Complete Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Outer Join\" \/>\n<meta property=\"og:description\" content=\"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-23T20:44:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T10:29:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"SQL Outer Join\",\"datePublished\":\"2020-02-23T20:44:26+00:00\",\"dateModified\":\"2023-12-01T10:29:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\"},\"wordCount\":1081,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\",\"name\":\"SQL Outer Join: A Complete Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg\",\"datePublished\":\"2020-02-23T20:44:26+00:00\",\"dateModified\":\"2023-12-01T10:29:51+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/careerkarma.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\/\/careerkarma.com\/blog\/sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Outer Join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\",\"url\":\"https:\/\/careerkarma.com\/blog\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/careerkarma.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Outer Join: A Complete Guide | Career Karma","description":"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.","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:\/\/careerkarma.com\/blog\/sql-outer-join\/","og_locale":"en_US","og_type":"article","og_title":"SQL Outer Join","og_description":"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.","og_url":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-02-23T20:44:26+00:00","article_modified_time":"2023-12-01T10:29:51+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"SQL Outer Join","datePublished":"2020-02-23T20:44:26+00:00","dateModified":"2023-12-01T10:29:51+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/"},"wordCount":1081,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-outer-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/","url":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/","name":"SQL Outer Join: A Complete Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg","datePublished":"2020-02-23T20:44:26+00:00","dateModified":"2023-12-01T10:29:51+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"SQL OUTER JOIN operators allow coders to query two or more tables and return only rows from either table that match. Learn more in this Career Karma article.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-outer-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-OUTER-JOIN.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-outer-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"SQL Outer Join"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=12395"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/12396"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=12395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=12395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=12395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}