{"id":607,"date":"2024-09-02T06:56:18","date_gmt":"2024-09-02T06:56:18","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=607"},"modified":"2025-06-06T06:17:00","modified_gmt":"2025-06-06T06:17:00","slug":"right-join","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/right-join\/","title":{"rendered":"RIGHT JOIN"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">SQL RIGHT JOIN Keyword<\/h2>\n\n\n\n<p>The RIGHT JOIN command returns all rows from the right table and the matching rows from the left table. If there is no match, the result from the left table will show as NULL.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL RIGHT JOIN Syntax<\/h2>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT column_names\nFROM table1\nRIGHT JOIN table2\nON table1.column_name = table2.column_name;<\/pre><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL RIGHT JOIN Doctors and Appointments Example<\/h2>\n\n\n\n<p>This query selects all doctors and any appointments they may have scheduled.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:false,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;default&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:false,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">SELECT Appointments.appointment_id, Doctors.doctor_id, Doctors.first_name\nFROM Appointments\nRIGHT JOIN Doctors ON Appointments.doctor_id = Doctors.doctor_id\nORDER BY Appointments.appointment_id;<\/pre><\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Note:<\/strong> This code does not work in the TechKubo playground. SQLite (and the TechKubo playground) does not support <code>RIGHT JOIN<\/code>. You can achieve similar results using <code>LEFT JOIN<\/code> by reversing the table order.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">SQL RIGHT JOIN Labs<\/h2>\n\n\n\n<iframe src=\"https:\/\/www.techkubo.com\/sql-sim.html\" title=\"Try SQL on TechKubo\" width=\"100%\" height=\"500\"><\/iframe>\n","protected":false},"excerpt":{"rendered":"<p>SQL RIGHT JOIN Keyword The RIGHT JOIN command returns all rows from the right table and the matching rows from [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","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":"","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":"default","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":[1],"tags":[],"class_list":["post-607","post","type-post","status-publish","format-standard","hentry","category-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>RIGHT JOIN - SQL Tutorial<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/techkubo.com\/sql\/right-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RIGHT JOIN - SQL Tutorial\" \/>\n<meta property=\"og:description\" content=\"SQL RIGHT JOIN Keyword The RIGHT JOIN command returns all rows from the right table and the matching rows from [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/techkubo.com\/sql\/right-join\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Tutorial\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-02T06:56:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-06T06:17:00+00:00\" \/>\n<meta name=\"author\" content=\"Manong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manong\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/\"},\"author\":{\"name\":\"Manong\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965\"},\"headline\":\"RIGHT JOIN\",\"datePublished\":\"2024-09-02T06:56:18+00:00\",\"dateModified\":\"2025-06-06T06:17:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/\"},\"wordCount\":96,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\"},\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/techkubo.com\/sql\/right-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/\",\"url\":\"https:\/\/techkubo.com\/sql\/right-join\/\",\"name\":\"RIGHT JOIN - SQL Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#website\"},\"datePublished\":\"2024-09-02T06:56:18+00:00\",\"dateModified\":\"2025-06-06T06:17:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/techkubo.com\/sql\/right-join\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/techkubo.com\/sql\/right-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/techkubo.com\/sql\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RIGHT JOIN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/techkubo.com\/sql\/#website\",\"url\":\"https:\/\/techkubo.com\/sql\/\",\"name\":\"SQL Tutorial\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/techkubo.com\/sql\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/techkubo.com\/sql\/#organization\",\"name\":\"SQL Tutorial\",\"url\":\"https:\/\/techkubo.com\/sql\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png\",\"contentUrl\":\"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png\",\"width\":1618,\"height\":1174,\"caption\":\"SQL Tutorial\"},\"image\":{\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965\",\"name\":\"Manong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/techkubo.com\/sql\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g\",\"caption\":\"Manong\"},\"sameAs\":[\"https:\/\/techkubo.com\"],\"url\":\"https:\/\/techkubo.com\/sql\/author\/manong\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RIGHT JOIN - SQL Tutorial","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:\/\/techkubo.com\/sql\/right-join\/","og_locale":"en_US","og_type":"article","og_title":"RIGHT JOIN - SQL Tutorial","og_description":"SQL RIGHT JOIN Keyword The RIGHT JOIN command returns all rows from the right table and the matching rows from [&hellip;]","og_url":"https:\/\/techkubo.com\/sql\/right-join\/","og_site_name":"SQL Tutorial","article_published_time":"2024-09-02T06:56:18+00:00","article_modified_time":"2025-06-06T06:17:00+00:00","author":"Manong","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manong","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/techkubo.com\/sql\/right-join\/#article","isPartOf":{"@id":"https:\/\/techkubo.com\/sql\/right-join\/"},"author":{"name":"Manong","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965"},"headline":"RIGHT JOIN","datePublished":"2024-09-02T06:56:18+00:00","dateModified":"2025-06-06T06:17:00+00:00","mainEntityOfPage":{"@id":"https:\/\/techkubo.com\/sql\/right-join\/"},"wordCount":96,"commentCount":0,"publisher":{"@id":"https:\/\/techkubo.com\/sql\/#organization"},"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/techkubo.com\/sql\/right-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/techkubo.com\/sql\/right-join\/","url":"https:\/\/techkubo.com\/sql\/right-join\/","name":"RIGHT JOIN - SQL Tutorial","isPartOf":{"@id":"https:\/\/techkubo.com\/sql\/#website"},"datePublished":"2024-09-02T06:56:18+00:00","dateModified":"2025-06-06T06:17:00+00:00","breadcrumb":{"@id":"https:\/\/techkubo.com\/sql\/right-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/techkubo.com\/sql\/right-join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/techkubo.com\/sql\/right-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/techkubo.com\/sql\/"},{"@type":"ListItem","position":2,"name":"RIGHT JOIN"}]},{"@type":"WebSite","@id":"https:\/\/techkubo.com\/sql\/#website","url":"https:\/\/techkubo.com\/sql\/","name":"SQL Tutorial","description":"","publisher":{"@id":"https:\/\/techkubo.com\/sql\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/techkubo.com\/sql\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/techkubo.com\/sql\/#organization","name":"SQL Tutorial","url":"https:\/\/techkubo.com\/sql\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/","url":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png","contentUrl":"https:\/\/techkubo.com\/sql\/wp-content\/uploads\/sites\/3\/2025\/01\/cropped-Techkubo-logo-1.png","width":1618,"height":1174,"caption":"SQL Tutorial"},"image":{"@id":"https:\/\/techkubo.com\/sql\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/b4fa2f01fa4ff2a4e98276ce47115965","name":"Manong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techkubo.com\/sql\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21a7455736c21887b8fefe0935012d65?s=96&d=mm&r=g","caption":"Manong"},"sameAs":["https:\/\/techkubo.com"],"url":"https:\/\/techkubo.com\/sql\/author\/manong\/"}]}},"_links":{"self":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/607"}],"collection":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":2,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/607\/revisions"}],"predecessor-version":[{"id":1558,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/posts\/607\/revisions\/1558"}],"wp:attachment":[{"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/media?parent=607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/categories?post=607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techkubo.com\/sql\/wp-json\/wp\/v2\/tags?post=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}