{"id":12371,"date":"2021-01-13T09:45:40","date_gmt":"2021-01-13T17:45:40","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12371"},"modified":"2023-12-01T04:08:03","modified_gmt":"2023-12-01T12:08:03","slug":"sql-left-join","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-left-join\/","title":{"rendered":"SQL Left Join: A Complete Guide"},"content":{"rendered":"\n<p><em>An SQL LEFT JOIN is a type of SQL join. This join returns all the tables from a specified &#8220;left&#8221; column and the corresponding rows that match a particular condition in the &#8220;right&#8221; column.<\/em><\/p>\n\n\n\n<p>In many cases, when you\u2019re writing a query in <em>SQL<\/em>, you\u2019ll only need to focus on a single table. However, there are many situations where you\u2019ll need to query two or more tables at the same time. In this situation, you will want to create a result that combines information from both tables.<\/p>\n\n\n\n<p>In <em>SQL<\/em>, this is referred to as a join. Joins allow you to get information from multiple tables and combine the result into a joined table. For example, you can join employees and departments tables together to get the department name for each employee.<\/p>\n\n\n\n<p>In this tutorial, we are going to break down one type of join in <em>SQL<\/em>: the <em>LEFT JOIN<\/em>. We\u2019ll discuss where <em>LEFT JOINs<\/em> are useful, and how you can use them in your <em>SQL<\/em> queries.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL LEFT JOIN<\/h2>\n\n\n\n<p>The SQL <em>LEFT JOIN<\/em> returns all records from a &#8220;left&#8221; table, specified in your query. It matches values from this table based on your conditions to a &#8220;right&#8221; table. Any matches are returned in addition to all records from the &#8220;left&#8221; table. _LEFT JOIN_s are a type of <a href=\"https:\/\/careerkarma.com\/blog\/sql-outer-join\/\">SQL outer join<\/a>.<\/p>\n\n\n\n<p>For example, you could use a left join to get a list of the department name for each employee. This would let you see all employees even if they don\u2019t have a department assigned.<\/p>\n\n\n\n<p>The basic syntax for a <em>LEFT JOIN<\/em> operation is as follows:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT Table1.Column1, Table2.Column1\nFROM Table1\nLEFT JOIN Table2\nON Table1.Column2 = Table1.Column2;<\/pre><\/div>\n\n\n\n<p>We start our join with an <a href=\"https:\/\/careerkarma.com\/blog\/sql-select\/\">SQL SELECT statement<\/a>. The table in the FROM statement is our &#8220;left&#8221; table. Then, we use the <em>LEFT JOIN<\/em> keyword. This lets us specify a &#8220;right&#8221; table.<\/p>\n\n\n\n<p>We use the ON statement to determine the condition on which our tables are connected. <em>LEFT JOINS<\/em> are a type of outer join. Thus, you may see this type of join referred to as <em>left outer joins<\/em>.<\/p>\n\n\n\n<p>Let\u2019s use an example to illustrate <em>LEFT JOINs<\/em> work.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">LEFT JOIN SQL Example<\/h2>\n\n\n\n<p>Say that we want to get a list of the department names where each employee works. We want to retrieve this information using one query. Here is a query that would allow us to get this data:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT employees.name, employees.title, company_departments.name AS DeptName\nFROM employees\nLEFT JOIN company_departments\nON employees.department_id = company_departments.department_id;<\/pre><\/div>\n\n\n\n<p>Our query returns seven records:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>name<\/td><td>title<\/td><td>deptname<\/td><\/tr><tr><td>Luke<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Mike<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Hannah<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Geoff<\/td><td>Senior Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Alexis<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Emma<\/td><td>Marketing Director<\/td><td>Marketing<\/td><\/tr><tr><td>Jonah<\/td><td>Vice President of Sales<\/td><td>Executive<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(7 rows)<\/p>\n\n\n\n<p>On the first line of our query, we specify that we want to get three columns. We retrieve the name of our employees, their titles, and the name of the department for which they work. The <em>AS DeptName<\/em> tells our query that the department name column should be called <em>DeptName<\/em>.<\/p>\n\n\n\n<p>On the next line, we specify that we want to get information from our <em>employees<\/em> table. Then, we create a <em>LEFT JOIN<\/em> between that table and <em>company_departments<\/em>. On the final line, we link our two tables together using their common values: department_id.<\/p>\n\n\n\n<p><em>LEFT JOINs<\/em> only return all rows from the left table and rows from the right table for which the join condition is met.<\/p>\n\n\n\n<p>If we have an employee with a department ID of <em>9<\/em> and that department does not exist, they will still appear in our query. If we have a company department that does not exist, it will not appear in our <em>JOIN<\/em> query.<\/p>\n\n\n\n<p>Let\u2019s run the query again, but this time with a new employee in our database. These are the values for our new employee:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>name<\/td><td>title<\/td><td>department_id<\/td><\/tr><tr><td>Adam<\/td><td>Senior Sales Associate<\/td><td>9<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>(1 row)<\/p>\n\n\n\n<p>The department ID <em>9<\/em> does not exist within our table <em>company_departments<\/em>. But when we run the same left join query as above, Adam\u2019s record is still included, because we are using a <em>LEFT JOIN<\/em>. Here is the result of the same <em>INNER JOIN<\/em> query we executed above, but with Adam\u2019s record:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>name<\/td><td>title<\/td><td>deptname<\/td><\/tr><tr><td>Luke<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Mike<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Hannah<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Geoff<\/td><td>Senior Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Alexis<\/td><td>Sales Associate<\/td><td>Sales<\/td><\/tr><tr><td>Emma<\/td><td>Marketing Director<\/td><td>Marketing<\/td><\/tr><tr><td>Jonah<\/td><td>Vice President of Sales<\/td><td>Executive<\/td><\/tr><tr><td>Adam<\/td><td>Senior Sales Associate<\/td><td><br><\/td><\/tr><\/tbody><\/table>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p><em>SQL LEFT JOINs<\/em> query more than one table and return all rows from a specified &#8220;left&#8221; table. They also return rows from the right table where the <em>JOIN<\/em> condition is met.<\/p>\n\n\n\n<p>For example, say you want to return a list of customers as well as the names of the loyalty plans they subscribe to. If the loyalty plan names are in a different table, you could use a left join to retrieve them.<\/p>\n\n\n\n<p>We&#8217;ve written a How to Learn SQL guide to help learners advance their knowledge of SQL. The guide contains a list of top learning resources and some expert advice to help you on your way. Check out the guide on our <a href=\"https:\/\/careerkarma.com\/blog\/learn-sql\/\">How to Learn SQL<\/a> page.<\/p>\n","protected":false},"excerpt":{"rendered":"An SQL LEFT JOIN is a type of SQL join. This join returns all the tables from a specified \"left\" column and the corresponding rows that match a particular condition in the \"right\" column. In many cases, when you\u2019re writing a query in SQL, you\u2019ll only need to focus on a single table. However, there&hellip;","protected":false},"author":240,"featured_media":12372,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-12371","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":null,"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 Left Join: A Complete Guide: A Complete Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this 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-left-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Left Join: A Complete Guide\" \/>\n<meta property=\"og:description\" content=\"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-left-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=\"2021-01-13T17:45:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T12:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"SQL Left Join: A Complete Guide\",\"datePublished\":\"2021-01-13T17:45:40+00:00\",\"dateModified\":\"2023-12-01T12:08:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/\"},\"wordCount\":841,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/\",\"name\":\"SQL Left Join: A Complete Guide: A Complete Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg\",\"datePublished\":\"2021-01-13T17:45:40+00:00\",\"dateModified\":\"2023-12-01T12:08:03+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this article.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-left-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-left-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 Left Join: A Complete Guide\"}]},{\"@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 Left Join: A Complete Guide: A Complete Guide | Career Karma","description":"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this 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-left-join\/","og_locale":"en_US","og_type":"article","og_title":"SQL Left Join: A Complete Guide","og_description":"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this article.","og_url":"https:\/\/careerkarma.com\/blog\/sql-left-join\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2021-01-13T17:45:40+00:00","article_modified_time":"2023-12-01T12:08:03+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"SQL Left Join: A Complete Guide","datePublished":"2021-01-13T17:45:40+00:00","dateModified":"2023-12-01T12:08:03+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/"},"wordCount":841,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-left-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/","url":"https:\/\/careerkarma.com\/blog\/sql-left-join\/","name":"SQL Left Join: A Complete Guide: A Complete Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg","datePublished":"2021-01-13T17:45:40+00:00","dateModified":"2023-12-01T12:08:03+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"The SQL LEFT JOIN function retrieves data from multiple tables and only returns data that exists within the two tables. Learn more in this article.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-left-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-left-join\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-LEFT-JOIN.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-left-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 Left Join: A Complete Guide"}]},{"@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\/12371","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=12371"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12371\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/12372"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=12371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=12371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=12371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}