{"id":175910,"date":"2024-01-06T18:37:41","date_gmt":"2024-01-06T17:37:41","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=175910"},"modified":"2024-01-06T18:43:24","modified_gmt":"2024-01-06T17:43:24","slug":"left-join-sql-learn-all-about-this-sql-command","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command","title":{"rendered":"SQL Join: Learn about Left Join and more"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"175910\" class=\"elementor elementor-175910\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d48fb85 e-flex e-con-boxed e-con\" data-id=\"d48fb85\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-22582fb elementor-widget elementor-widget-heading\" data-id=\"22582fb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">An SQL Join makes relational database management easy, thanks to joins that link two or more tables by means of common columns. The LEFT JOIN (or LEFT OUTER JOIN) command takes things a step further...<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b51230b e-flex e-con-boxed e-con\" data-id=\"b51230b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-07fb784 elementor-widget elementor-widget-text-editor\" data-id=\"07fb784\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>SQL is a query language<\/strong> that is inherently associated with relational databases. The reason it&#8217;s so popular is that its syntax is relatively simple to learn, paving the way for the easy creation and manipulation of tables and, from there, databases linking these tables. Its strength lies in its ability to extract very <a href=\"https:\/\/datascientest.com\/en\/refactoring-databases-and-code-comprehensive-guide-to-the-essentials\">precise information from vast databases.<\/a><\/p><p>However, one of the strengths of this language lies in its ability to establish joins between data tables. What does this mean? By combining data from several tables, we can obtain cross-references of particular interest to the data scientist.<\/p><p>Joins are therefore an essential element of SQL. But there are two types of joins you can think of&#8230;<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b49b145 e-flex e-con-boxed e-con\" data-id=\"b49b145\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cb43d21 elementor-widget elementor-widget-heading\" data-id=\"cb43d21\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What are the 2 types of the SQL JOIN?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54e2a07 elementor-widget elementor-widget-text-editor\" data-id=\"54e2a07\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The two types of joins are internal and external. What exactly are they?<\/p><ul><li><strong>Internal (INNER):<\/strong> this is a join that extracts data based on column correspondences between two tables, according to a condition. For example, two or more tables can be associated on the basis of the column name, city, product_number&#8230; Thus, if we have a table that lists the films in a videoclub in great detail (actors, director, year of release) and another, much simpler table that indicates which films have been rented, we could easily obtain a detailed list of films currently on rental. The condition used is usually the equality operator, but it can also be &lt;, &lt;=, &gt;, etc.<\/li><li><strong>External (OUTER)<\/strong>: this join extracts records with matches as in the previous case, but also brings up records with no matches between the 1st, 2nd and other tables. We&#8217;ll see below how useful this type of external join can be.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6d758da e-flex e-con-boxed e-con\" data-id=\"6d758da\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-04dbb4c elementor-widget elementor-widget-heading\" data-id=\"04dbb4c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Three types of external joints<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0040cb7 elementor-widget elementor-widget-text-editor\" data-id=\"0040cb7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>We have three types of external <strong>SQL joins<\/strong> available.<\/p><ul><li><strong>LEFT JOIN \/ LEFT OUTER JOIN:<\/strong> &#8220;left&#8221; join (with the table following the FROM command)<\/li><li><strong>RIGHT JOIN \/ RIGHT OUTER JOIN<\/strong> (with the table to the right of the operator)<\/li><li><strong>FULL JOIN \/ FULL OUTER JOIN<\/strong> (to extract rows from 2 tables)<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8451710 elementor-widget elementor-widget-text-editor\" data-id=\"8451710\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In practice, it&#8217;s the <strong>LEFT JOIN<\/strong> command that&#8217;s most often used, because it&#8217;s so obvious, as we&#8217;ll see in an example below.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c0cefb elementor-widget elementor-widget-image\" data-id=\"5c0cefb\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/06\/jointures-sql.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4e3d67 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e4e3d67\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn all about SQL joins<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3705381 e-flex e-con-boxed e-con\" data-id=\"3705381\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9a9469e elementor-widget elementor-widget-heading\" data-id=\"9a9469e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SQL JOIN: The LEFT JOIN<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3e87fd elementor-widget elementor-widget-text-editor\" data-id=\"a3e87fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>LEFT JOIN<\/strong> <a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-knowhttps:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">SQL command<\/a> is the most commonly used external join command. It lists all elements common to two tables, as well as all elements in the left-hand table (the table following FROM).<\/p><p><strong>Let&#8217;s consider two tables:<\/strong> Table1 and Table2, with Table1 being the left-hand table. The LEFT JOIN will list all results from the left-hand table (Table1), even if there is no correspondence between the two tables.<\/p><p>The syntax could be as follows:<\/p><p>SELECT *<\/p><p>FROM table1<\/p><p>LEFT JOIN table 2<\/p><p>ON table1.id = table2.id<\/p><p>So the LEFT JOIN command examines every row in table1. If it finds a match, it displays the data found in table2. But what does the LEFT JOIN command do when there is no match between the two tables? It returns NULLs for the column in question.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;NoSQL: All about non-relational databases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\" target=\"_blank\" rel=\"noopener\">NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-68f7bf9 e-flex e-con-boxed e-con\" data-id=\"68f7bf9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b39f2c5 elementor-widget elementor-widget-heading\" data-id=\"b39f2c5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What use is the SQL JOIN LEFT JOIN for?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9cb6c81 elementor-widget elementor-widget-text-editor\" data-id=\"9cb6c81\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><em>So what&#8217;s the point of such an order?<\/em> Let&#8217;s imagine we have two tables. The first, Customers, lists all the company&#8217;s customers. The second, Orders, lists all the orders placed by some of these customers.<\/p><p>With an internal join, we could have a list of all customers who have placed one or more orders.<\/p><p>Suppose, however, that we wanted to know the status of all the company&#8217;s customers, whether or not they had placed an order. We could obtain this type of information with <strong>LEFT JOIN.<\/strong><\/p><p>This would enable the company to identify registered customers who have never placed an order, and to target them specifically with promotional offers, or to find out why they have never been interested in the company&#8217;s products or services.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c46de2 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"3c46de2\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Training in SQL language<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7cf9999 e-flex e-con-boxed e-con\" data-id=\"7cf9999\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0fd3099 elementor-widget elementor-widget-html\" data-id=\"0fd3099\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What are the 2 joint types?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Internal (INNER): this is a join that extracts data based on column correspondences between two tables, according to a condition. For example, two or more tables can be associated on the basis of the column name, city, product_number... In this way, if we have a table listing the films in a videoclub with full details (actors, director, year of release) and another, much simpler table indicating which films have been rented, we could easily obtain a detailed list of films currently on rental. The condition used is usually the equality operator, but it can also be <, <=, >, etc. External (OUTER): this join extracts records with matches as in the previous case, but also brings up records with no matches between the 1st, 2nd and other tables. We'll see how useful this type of external join can be later on.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"The LEFT JOIN\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The LEFT JOIN command is the most commonly used external join command. It lists all elements common to two tables, as well as all elements in the left-hand table (the table following FROM). Let's consider two tables: Table1 and Table2, with Table1 being the left-hand table. The LEFT JOIN will list all results from the left-hand table (Table1), even if there is no correspondence between the two tables.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What use for LEFT JOIN?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"What could possibly be the point of such a command? Let's imagine we have two tables. The first, Customers, lists all the company's customers. The second, Orders, lists all the orders placed by some of these customers.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>An SQL Join makes relational database management easy, thanks to joins that link two or more tables by means of common columns. The LEFT JOIN (or LEFT OUTER JOIN) command takes things a step further&#8230; SQL is a query language that is inherently associated with relational databases. The reason it&#8217;s so popular is that its [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":175912,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Join: Learn about Left Join and more<\/title>\n<meta name=\"description\" content=\"An SQL Join is particularly useful in certain situations, with the flexibility to handle cases where there might not ..\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Join: Learn about Left Join and more\" \/>\n<meta property=\"og:description\" content=\"An SQL Join makes relational database management easy, thanks to joins that link two or more tables by means of common columns. The LEFT JOIN (or LEFT\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-06T17:37:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-06T17:43:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/SQL_left_join-768x422-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL Join: Learn about Left Join and more\",\"datePublished\":\"2024-01-06T17:37:41+00:00\",\"dateModified\":\"2024-01-06T17:43:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\"},\"wordCount\":715,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\",\"url\":\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\",\"name\":\"SQL Join: Learn about Left Join and more\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-06T17:37:41+00:00\",\"dateModified\":\"2024-01-06T17:43:24+00:00\",\"description\":\"An SQL Join is particularly useful in certain situations, with the flexibility to handle cases where there might not ..\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Join: Learn about Left Join and more","description":"An SQL Join is particularly useful in certain situations, with the flexibility to handle cases where there might not ..","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:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command","og_locale":"en_GB","og_type":"article","og_title":"SQL Join: Learn about Left Join and more","og_description":"An SQL Join makes relational database management easy, thanks to joins that link two or more tables by means of common columns. The LEFT JOIN (or LEFT","og_url":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-06T17:37:41+00:00","article_modified_time":"2024-01-06T17:43:24+00:00","og_image":[{"width":768,"height":422,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/SQL_left_join-768x422-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL Join: Learn about Left Join and more","datePublished":"2024-01-06T17:37:41+00:00","dateModified":"2024-01-06T17:43:24+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command"},"wordCount":715,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command","url":"https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command","name":"SQL Join: Learn about Left Join and more","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-06T17:37:41+00:00","dateModified":"2024-01-06T17:43:24+00:00","description":"An SQL Join is particularly useful in certain situations, with the flexibility to handle cases where there might not ..","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/left-join-sql-learn-all-about-this-sql-command"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175910"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=175910"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175910\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/175912"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=175910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=175910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=175910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}