{"id":78347,"date":"2022-08-05T00:36:16","date_gmt":"2022-08-04T19:06:16","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/"},"modified":"2025-06-18T17:07:38","modified_gmt":"2025-06-18T11:37:38","slug":"sql-joins","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/","title":{"rendered":"SQL Joins - Inner, Left, Right &amp; Full Join"},"content":{"rendered":"\n<p>If you want to analyze information in multiple tables, you need to know SQL joins, a basic skill for data analysts, software developers and database managers. Putting joins to use gives you powerful options for combining related information necessary for creating advanced reports, dashboards and apps.<\/p>\n\n\n\n<p>In this article, we\u2019ll break down the four core SQL join types: Inner Join, Left Join, Right Join, and Full Join, explaining their use cases and providing clear examples. By the end, you'll confidently use joins to extract meaningful insights from your databases.<\/p>\n\n\n\n    <div class=\"courses-cta-container\">\n        <div class=\"courses-cta-card\">\n            <div class=\"courses-cta-header\">\n                <div class=\"courses-learn-icon\"><\/div>\n                <span class=\"courses-learn-text\">Academy Pro<\/span>\n            <\/div>\n            <p class=\"courses-cta-title\">\n                <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/practical-sql-training\" class=\"courses-cta-title-link\">SQL Course<\/a>\n            <\/p>\n            <p class=\"courses-cta-description\">Master SQL and Database management with this SQL course: Practical training with guided projects, AI support, and expert instructors.<\/p>\n            <div class=\"courses-cta-stats\">\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-user-icon\"><\/div>\n                    <span>7 Hrs<\/span>\n                <\/div>\n                <div class=\"courses-stat-item\">\n                    <div class=\"courses-stat-icon courses-star-icon\"><\/div>\n                    <span>2 Projects<\/span>\n                <\/div>\n            <\/div>\n            <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/practical-sql-training\" class=\"courses-cta-button\">\n                Take SQL Course Now\n                <div class=\"courses-arrow-icon\"><\/div>\n            <\/a>\n        <\/div>\n    <\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"why-are-sql-joins-important\">Why Are SQL Joins Important?<\/h2>\n\n\n\n<p>Relational databases store data in multiple tables to reduce redundancy. Joins allow you to retrieve data that spans multiple tables based on relationships between columns, typically using keys.<\/p>\n\n\n\n<p>For example, in an e-commerce database:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Customers<\/code> table stores customer info.<\/li>\n\n\n\n<li><code>Orders<\/code> table stores order details linked to customers by <code>customer_id<\/code>.<\/li>\n<\/ul>\n\n\n\n<p>To get customer names with their orders, you join these tables on <code>customer_id<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"types-of-sql-joins-with-examples\">Types of SQL Joins with Examples<\/h2>\n\n\n<figure class=\"wp-block-image aligncenter size-large zoomable\" data-full=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types.webp\"><img decoding=\"async\" width=\"1024\" height=\"683\" src=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types-1024x683.webp\" alt=\"Types of SQL Joins\" class=\"wp-image-108692\" srcset=\"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types-1024x683.webp 1024w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types-300x200.webp 300w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types-768x512.webp 768w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types-150x100.webp 150w, https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/sql-joins-types.webp 1536w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-inner-join\">1. Inner Join<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-inner-join\">What is Inner Join?<\/h4>\n\n\n\n<p>Inner Join returns only rows where there is a match in both joined tables. If a row in one table has no corresponding row in the other, it won\u2019t appear in the result. You can use <a href=\"https:\/\/www.mygreatlearning.com\/blog\/sql-commands\/\">SQL commands<\/a> like <code>SELECT<\/code>, <code>FROM<\/code>, and <code>INNER JOIN<\/code> to achieve this.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"use-case\">Use Case<\/h4>\n\n\n\n<p>Retrieve records that exist in both tables.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"syntax\">Syntax<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT columns\nFROM table1\nINNER JOIN table2 ON table1.common_column = table2.common_column;\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"example\">Example<\/h4>\n\n\n\n<p>Suppose we have two tables:<\/p>\n\n\n\n<p><b>Customers<\/b><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>customer_id<\/th><th>customer_name<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Alice<\/td><\/tr><tr><td>2<\/td><td>Bob<\/td><\/tr><tr><td>3<\/td><td>Charlie<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><b>Orders<\/b><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>order_id<\/th><th>customer_id<\/th><th>amount<\/th><\/tr><\/thead><tbody><tr><td>101<\/td><td>1<\/td><td>250<\/td><\/tr><tr><td>102<\/td><td>3<\/td><td>450<\/td><\/tr><tr><td>103<\/td><td>4<\/td><td>300<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Query:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Customers.customer_name, Orders.order_id, Orders.amount\nFROM Customers\nINNER JOIN Orders ON Customers.customer_id = Orders.customer_id;\n<\/pre><\/div>\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>customer_name<\/th><th>order_id<\/th><th>amount<\/th><\/tr><\/thead><tbody><tr><td>Alice<\/td><td>101<\/td><td>250<\/td><\/tr><tr><td>Charlie<\/td><td>102<\/td><td>450<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Note: Bob (customer_id 2) and order 103 (customer_id 4) do not appear because there\u2019s no matching record in the other table.<\/p>\n\n\n\n<p><strong>Also Read-<\/strong> <a href=\"https:\/\/www.mygreatlearning.com\/blog\/sql-functions\/\">SQL Functions: Aggregate and Scalar Functions with Examples<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-left-join-or-left-outer-join\">2. Left Join (or Left Outer Join)<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-left-join\">What is Left Join?<\/h4>\n\n\n\n<p>Returns all records from the left table and matched records from the right table. If no match exists, columns from the right table are <code>NULL<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"use-case\">Use Case<\/h4>\n\n\n\n<p>When you want all records from the main table, regardless of whether they have matches in the joined table.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"syntax\">Syntax<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT columns\nFROM table1\nLEFT JOIN table2 ON table1.common_column = table2.common_column;\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"example\">Example<\/h4>\n\n\n\n<p>Using the same tables, query:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Customers.customer_name, Orders.order_id, Orders.amount\nFROM Customers\nLEFT JOIN Orders ON Customers.customer_id = Orders.customer_id;\n<\/pre><\/div>\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>customer_name<\/th><th>order_id<\/th><th>amount<\/th><\/tr><\/thead><tbody><tr><td>Alice<\/td><td>101<\/td><td>250<\/td><\/tr><tr><td>Bob<\/td><td>NULL<\/td><td>NULL<\/td><\/tr><tr><td>Charlie<\/td><td>102<\/td><td>450<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Bob appears with <code>NULL<\/code> order values because he has no orders.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-right-join-or-right-outer-join\">3. Right Join (or Right Outer Join)<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-the-right-join\">What is the Right Join?<\/h4>\n\n\n\n<p>Returns all records from the right table and matched records from the left table. If no match exists, columns from the left table are <code>NULL<\/code>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"use-case\">Use Case<\/h4>\n\n\n\n<p>Less commonly used but useful when you want all rows from the joined table (right table) with related left table info.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"syntax\">Syntax<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT columns\nFROM table1\nRIGHT JOIN table2 ON table1.common_column = table2.common_column;\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"example\">Example<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Customers.customer_name, Orders.order_id, Orders.amount\nFROM Customers\nRIGHT JOIN Orders ON Customers.customer_id = Orders.customer_id;\n<\/pre><\/div>\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>customer_name<\/th><th>order_id<\/th><th>amount<\/th><\/tr><\/thead><tbody><tr><td>Alice<\/td><td>101<\/td><td>250<\/td><\/tr><tr><td>Charlie<\/td><td>102<\/td><td>450<\/td><\/tr><tr><td>NULL<\/td><td>103<\/td><td>300<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Order 103 appears with <code>NULL<\/code> customer info because there\u2019s no matching <code>customer_id<\/code> 4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-full-join-or-full-outer-join\">4. Full Join (or Full Outer Join)<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"what-is-full-join\">What is Full Join?<\/h4>\n\n\n\n<p>Returns all records when there is a match in either the left or right table. Non-matching rows from both tables show with <code>NULL<\/code> in missing columns.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"use-case\">Use Case<\/h4>\n\n\n\n<p>When you want to combine all data from both tables regardless of matches.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"syntax\">Syntax<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT columns\nFROM table1\nFULL OUTER JOIN table2 ON table1.common_column = table2.common_column;\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"example\">Example<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT Customers.customer_name, Orders.order_id, Orders.amount\nFROM Customers\nFULL OUTER JOIN Orders ON Customers.customer_id = Orders.customer_id;\n<\/pre><\/div>\n\n\n<p>Result:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>customer_name<\/th><th>order_id<\/th><th>amount<\/th><\/tr><\/thead><tbody><tr><td>Alice<\/td><td>101<\/td><td>250<\/td><\/tr><tr><td>Bob<\/td><td>NULL<\/td><td>NULL<\/td><\/tr><tr><td>Charlie<\/td><td>102<\/td><td>450<\/td><\/tr><tr><td>NULL<\/td><td>103<\/td><td>300<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>This result shows every row from both tables, filling with <code>NULL<\/code> when no match.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"summary-table\">Summary Table<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Join Type<\/th><th>Returns<\/th><th>Missing Match Behavior<\/th><\/tr><\/thead><tbody><tr><td>Inner Join<\/td><td>Only matching rows in both tables<\/td><td>Excludes unmatched rows<\/td><\/tr><tr><td>Left Join<\/td><td>All rows from left table + matching right<\/td><td>Unmatched right columns = NULL<\/td><\/tr><tr><td>Right Join<\/td><td>All rows from right table + matching left<\/td><td>Unmatched left columns = NULL<\/td><\/tr><tr><td>Full Join<\/td><td>All rows from both tables<\/td><td>Unmatched columns = NULL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"practical-tips-for-using-joins\">Practical Tips for Using Joins<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Always use explicit <code>JOIN<\/code> syntax (not comma-separated tables with <code>WHERE<\/code>) for readability and maintainability.<\/li>\n\n\n\n<li>Index your join columns (<code>customer_id<\/code> etc.) for faster queries.<\/li>\n\n\n\n<li>Use <code>INNER JOIN<\/code> when you want to filter to related data only.<\/li>\n\n\n\n<li>Use <code>LEFT JOIN<\/code> when you want to keep all records from a primary table and fill optional related data.<\/li>\n\n\n\n<li>Use <code>FULL JOIN<\/code> when merging datasets with partial overlap.<\/li>\n\n\n\n<li>Be mindful that <code>RIGHT JOIN<\/code> is often replaced by switching table positions and using <code>LEFT JOIN<\/code> for clarity.<\/li>\n<\/ul>\n\n\n\n<p>Want to learn deeply about Data Analysis in SQL?<\/p>\n\n\n\n<p>Accelerate your skills with this <a href=\"https:\/\/www.mygreatlearning.com\/academy\/premium\/master-data-analytics-in-sql-excel\">Data Analytics in SQL &amp; Excel Course<\/a>. Learn to analyze data, write powerful SQL queries, and build dashboards using Excel ideal for aspiring data analysts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p>Understanding joins is foundational and mastering them gives you leverage in complex data projects, BI tools, and backend development.<\/p>\n\n\n\n<p>So, this is pretty much all about the Joins in SQL. You can get your hands on <a href=\"https:\/\/www.mygreatlearning.com\/sql\/free-courses\">free SQL courses<\/a> to upskill yourself with the concept and earn a completion certificate.<\/p>\n\n\n\n<p>Happy Learning!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"frequently-asked-questions-faqs\">Frequently Asked Questions (FAQ\u2019s)<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><b>Can SQL joins cause performance issues, and how can they be optimized?<\/b><br>Yes, joins especially on large tables can slow down queries. Optimizing involves indexing join columns, minimizing the result set with filters, avoiding unnecessary joins, and using query execution plans to identify bottlenecks.<\/li>\n\n\n\n<li><b>What is the difference between CROSS JOIN and INNER JOIN?<\/b><br>A <code>CROSS JOIN<\/code> returns the Cartesian product of both tables (all combinations), which can create a very large result set. <code>INNER JOIN<\/code> returns only matching rows based on a condition.<\/li>\n\n\n\n<li><b>How do NULL values affect join results in different join types?<\/b><br><code>NULL<\/code>s in join columns generally prevent matches in <code>INNER<\/code>, <code>LEFT<\/code>, and <code>RIGHT<\/code> joins. Special care with functions like <code>COALESCE<\/code> or conditional joins may be needed to handle <code>NULL<\/code>s explicitly.<\/li>\n\n\n\n<li><b>How does JOIN behavior differ in SQL vs. NoSQL databases?<\/b><br>Traditional SQL joins work on relational data with structured schemas. NoSQL databases often don\u2019t support joins natively and require data denormalization or application-side joins.<\/li>\n\n\n\n<li><b>What is a Self Join, and when would you use it?<\/b><br>A self join is when a table is joined with itself to compare or relate rows within the same table. It\u2019s commonly used to work with hierarchical data, such as employees and their managers, or to find related rows within one dataset. For example, you might use a self join to list employees alongside their managers by matching employee records with other employee records.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to analyze information in multiple tables, you need to know SQL joins, a basic skill for data analysts, software developers and database managers. Putting joins to use gives you powerful options for combining related information necessary for creating advanced reports, dashboards and apps. In this article, we\u2019ll break down the four core [&hellip;]<\/p>\n","protected":false},"author":41,"featured_media":78438,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[25860],"tags":[36844],"content_type":[],"class_list":["post-78347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software","tag-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Types of SQL Joins (Inner, Left, Right &amp; Full Join) with Examples<\/title>\n<meta name=\"description\" content=\"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Joins - Inner, Left, Right &amp; Full Join\" \/>\n<meta property=\"og:description\" content=\"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-04T19:06:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-18T11:37:38+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"1118\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\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:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"SQL Joins - Inner, Left, Right &amp; Full Join\",\"datePublished\":\"2022-08-04T19:06:16+00:00\",\"dateModified\":\"2025-06-18T11:37:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/\"},\"wordCount\":984,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-schema-1895779_1280-1.png\",\"keywords\":[\"sql\"],\"articleSection\":[\"IT\\\/Software Development\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/\",\"name\":\"Types of SQL Joins (Inner, Left, Right & Full Join) with Examples\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-schema-1895779_1280-1.png\",\"datePublished\":\"2022-08-04T19:06:16+00:00\",\"dateModified\":\"2025-06-18T11:37:38+00:00\",\"description\":\"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-schema-1895779_1280-1.png\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/database-schema-1895779_1280-1.png\",\"width\":1280,\"height\":1118,\"caption\":\"sql joins\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/sql-joins\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IT\\\/Software Development\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/software\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Joins - Inner, Left, Right &amp; Full Join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill &amp; Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Types of SQL Joins (Inner, Left, Right & Full Join) with Examples","description":"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/","og_locale":"en_US","og_type":"article","og_title":"SQL Joins - Inner, Left, Right &amp; Full Join","og_description":"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.","og_url":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2022-08-04T19:06:16+00:00","article_modified_time":"2025-06-18T11:37:38+00:00","og_image":[{"width":1280,"height":1118,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png","type":"image\/png"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"SQL Joins - Inner, Left, Right &amp; Full Join","datePublished":"2022-08-04T19:06:16+00:00","dateModified":"2025-06-18T11:37:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/"},"wordCount":984,"commentCount":0,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png","keywords":["sql"],"articleSection":["IT\/Software Development"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/","url":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/","name":"Types of SQL Joins (Inner, Left, Right & Full Join) with Examples","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png","datePublished":"2022-08-04T19:06:16+00:00","dateModified":"2025-06-18T11:37:38+00:00","description":"Learn the differences between Inner Join, Left Join, Right Join, and Full Join in SQL with clear examples. Master SQL joins to query multiple tables efficiently.","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png","width":1280,"height":1118,"caption":"sql joins"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/sql-joins\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"IT\/Software Development","item":"https:\/\/www.mygreatlearning.com\/blog\/software\/"},{"@type":"ListItem","position":3,"name":"SQL Joins - Inner, Left, Right &amp; Full Join"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill &amp; Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png",1280,1118,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-150x150.png",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-300x262.png",300,262,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-768x671.png",768,671,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-1024x894.png",1024,894,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png",1280,1118,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1.png",1280,1118,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-640x853.png",640,853,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-96x96.png",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/08\/database-schema-1895779_1280-1-150x131.png",150,131,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"If you want to analyze information in multiple tables, you need to know SQL joins, a basic skill for data analysts, software developers and database managers. Putting joins to use gives you powerful options for combining related information necessary for creating advanced reports, dashboards and apps. In this article, we\u2019ll break down the four core&hellip;","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/78347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=78347"}],"version-history":[{"count":8,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/78347\/revisions"}],"predecessor-version":[{"id":115197,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/78347\/revisions\/115197"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/78438"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=78347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=78347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=78347"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=78347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}