{"id":313,"date":"2019-04-06T00:41:32","date_gmt":"2019-04-06T08:41:32","guid":{"rendered":"https:\/\/db2tutorial.com\/?page_id=313"},"modified":"2020-04-11T06:59:38","modified_gmt":"2020-04-11T14:59:38","slug":"db2-full-outer-join","status":"publish","type":"page","link":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/","title":{"rendered":"Db2 FULL OUTER JOIN"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the Db2 <code>FULL OUTER JOIN<\/code> to query data from two tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to Db2 FULL OUTER JOIN clause<\/h2>\n\n\n\n<p>Suppose you have two tables named <code>T1<\/code> and <code>T2<\/code>, which are called the left table and the right table respectively.<\/p>\n\n\n\n<p>The <code>FULL OUTER JOIN<\/code> of the <code>T1<\/code> and <code>T2<\/code> returns a result set which includes rows from both left and right tables. When no matching rows exist for the row from the left table, the columns of the right table are filled with <code>NULL<\/code>. Similarly, when no matching rows exist for the row from the right table, the columns of the left table will be filled with <code>NULL<\/code>.<\/p>\n\n\n\n<p>The following shows the syntax of the <code>FULL OUTER JOIN<\/code> when joining two tables:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n    select_list\n<span class=\"hljs-keyword\">FROM<\/span> \n    T1\n<span class=\"hljs-keyword\">FULL<\/span> <span class=\"hljs-keyword\">OUTER<\/span> <span class=\"hljs-keyword\">JOIN<\/span> T2 <span class=\"hljs-keyword\">ON<\/span> join_condition;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The <code>OUTER<\/code> keyword is optional so you can omit it as shown in the following query:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n    select_list\n<span class=\"hljs-keyword\">FROM<\/span> \n    T1\n<span class=\"hljs-keyword\">FULL<\/span> <span class=\"hljs-keyword\">JOIN<\/span> T2 <span class=\"hljs-keyword\">ON<\/span> join_condition;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>First, specify the left table <code>T1<\/code> in the <code>FROM<\/code> clause.<\/li><li>Second, specify the right table <code>T2<\/code> and a join condition.<\/li><\/ul>\n\n\n\n<p>This Venn diagram illustrates the <code>FULL OUTER JOIN<\/code> of two result sets <code>T1<\/code> and <code>T2<\/code>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"325\" height=\"196\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png\" alt=\"db2 full outer join\" class=\"wp-image-314\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png 325w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-300x181.png 300w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Db2 FULL OUTER JOIN examples<\/h2>\n\n\n\n<p>Let&#8217;s take some examples of using the <code>FULL OUTER JOIN<\/code> clause.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Using Db2 FULL OUTER JOIN to join two tables example<\/h3>\n\n\n\n<p>This database diagram shows the <code>books<\/code> and <code>publishers<\/code> tables:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"207\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers.png\" alt=\"\" class=\"wp-image-74\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers.png 450w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/03\/books-and-publishers-300x138.png 300w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/figure>\n\n\n\n<p>In this diagram, a publisher may have zero or many books while a book may belong to zero or one publisher. The relationship between the <code>books<\/code> table and the <code>publishers<\/code> table is zero-to-many. The <code>publisher_id<\/code> column in both tables links a book to a publisher and vice versa.<\/p>\n\n\n\n<p>Note that in case a book does not associate with any publisher, maybe the publisher was unknown at the time of inserting, the value in the <code>publisher_id<\/code> column of the <code>books<\/code> table is NULL.<\/p>\n\n\n\n<p>The following query uses the <code>FULL OUTER JOIN<\/code> clause to join the <code>books<\/code> table with the <code>publishers<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>    \n    b.title, \n    p.name <span class=\"hljs-keyword\">AS<\/span> publisher\n<span class=\"hljs-keyword\">FROM<\/span>    \n    books b\n    <span class=\"hljs-keyword\">FULL<\/span> <span class=\"hljs-keyword\">OUTER<\/span> <span class=\"hljs-keyword\">JOIN<\/span> publishers p \n        <span class=\"hljs-keyword\">ON<\/span> p.publisher_id = b.publisher_id\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> \n    b.title <span class=\"hljs-keyword\">NULLS<\/span> <span class=\"hljs-keyword\">FIRST<\/span>, \n    publisher;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Here is the output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"699\" height=\"397\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-example.png\" alt=\"db2 full outer join example\" class=\"wp-image-316\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-example.png 699w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-example-300x170.png 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/figure>\n\n\n\n<p>In this example, the query returned books with publishers, books who do not have publishers, and publishers that do have any books.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2) Using Db2 FULL OUTER JOIN to find the missing rows example<\/h3>\n\n\n\n<p>To find the publishers who do not have any books and books which do not associate with any publisher, you add a <code><a href=\"https:\/\/db2tutorial.com\/db2-basics\/db2-where\/\">WHERE<\/a><\/code> clause to check if the book title <code><a href=\"https:\/\/db2tutorial.com\/db2-basics\/db2-or\/\">OR<\/a><\/code> publisher name <code>IS NULL<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span>    \n    b.title, \n    p.name <span class=\"hljs-keyword\">AS<\/span> publisher\n<span class=\"hljs-keyword\">FROM<\/span>    \n    books b\n    <span class=\"hljs-keyword\">FULL<\/span> <span class=\"hljs-keyword\">OUTER<\/span> <span class=\"hljs-keyword\">JOIN<\/span> publishers p \n        <span class=\"hljs-keyword\">ON<\/span> p.publisher_id = b.publisher_id\n<span class=\"hljs-keyword\">WHERE<\/span> b.title <span class=\"hljs-keyword\">IS<\/span> <span class=\"hljs-literal\">NULL<\/span>\n        <span class=\"hljs-keyword\">OR<\/span> p.name <span class=\"hljs-keyword\">IS<\/span> <span class=\"hljs-literal\">NULL<\/span>\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> \n    b.title <span class=\"hljs-keyword\">NULLS<\/span> <span class=\"hljs-keyword\">FIRST<\/span>, \n    publisher;\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>This picture shows the partial output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"757\" height=\"343\" src=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-find-missing-rows.png\" alt=\"db2 full outer join find missing rows\" class=\"wp-image-315\" srcset=\"https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-find-missing-rows.png 757w, https:\/\/www.db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join-find-missing-rows-300x136.png 300w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<p>In this tutorial, you have learned how to use the Db2 <code>FULL OUTER JOIN<\/code> to query data from two tables.<\/p>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful ?<\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"313\"\n\t\t\t\tdata-post-url=\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\"\n\t\t\t\tdata-post-title=\"Db2 FULL OUTER JOIN\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"313\"\n\t\t\t\tdata-post-url=\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\"\n\t\t\t\tdata-post-title=\"Db2 FULL OUTER JOIN\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to use the Db2 FULL OUTER JOIN to query data from two tables.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":141,"menu_order":16,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-313","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Db2 FULL OUTER JOIN Illustrated by Practical Examples<\/title>\n<meta name=\"description\" content=\"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.\" \/>\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.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Db2 FULL OUTER JOIN Illustrated by Practical Examples\" \/>\n<meta property=\"og:description\" content=\"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\" \/>\n<meta property=\"og:site_name\" content=\"DB2 Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-11T14:59:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\",\"url\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\",\"name\":\"Db2 FULL OUTER JOIN Illustrated by Practical Examples\",\"isPartOf\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png\",\"datePublished\":\"2019-04-06T08:41:32+00:00\",\"dateModified\":\"2020-04-11T14:59:38+00:00\",\"description\":\"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage\",\"url\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png\",\"contentUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.db2tutorial.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Db2 Basics\",\"item\":\"https:\/\/www.db2tutorial.com\/db2-basics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Db2 FULL OUTER JOIN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.db2tutorial.com\/#website\",\"url\":\"https:\/\/www.db2tutorial.com\/\",\"name\":\"DB2 Tutorial\",\"description\":\"A Comprehensive DB2 Tutorial\",\"publisher\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.db2tutorial.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.db2tutorial.com\/#organization\",\"name\":\"Db2 Tutorial\",\"url\":\"https:\/\/www.db2tutorial.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png\",\"contentUrl\":\"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png\",\"width\":500,\"height\":500,\"caption\":\"Db2 Tutorial\"},\"image\":{\"@id\":\"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Db2 FULL OUTER JOIN Illustrated by Practical Examples","description":"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.","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.db2tutorial.com\/db2-basics\/db2-full-outer-join\/","og_locale":"en_US","og_type":"article","og_title":"Db2 FULL OUTER JOIN Illustrated by Practical Examples","og_description":"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.","og_url":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/","og_site_name":"DB2 Tutorial","article_modified_time":"2020-04-11T14:59:38+00:00","og_image":[{"url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/","url":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/","name":"Db2 FULL OUTER JOIN Illustrated by Practical Examples","isPartOf":{"@id":"https:\/\/www.db2tutorial.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage"},"image":{"@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage"},"thumbnailUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png","datePublished":"2019-04-06T08:41:32+00:00","dateModified":"2020-04-11T14:59:38+00:00","description":"This tutorial shows you how to use the Db2 FULL OUTER JOIN to query data from two tables. It also shows you to find the missing rows from related tables using FULL JOIN.","breadcrumb":{"@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#primaryimage","url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png","contentUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/04\/db2-full-outer-join.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.db2tutorial.com\/db2-basics\/db2-full-outer-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.db2tutorial.com\/"},{"@type":"ListItem","position":2,"name":"Db2 Basics","item":"https:\/\/www.db2tutorial.com\/db2-basics\/"},{"@type":"ListItem","position":3,"name":"Db2 FULL OUTER JOIN"}]},{"@type":"WebSite","@id":"https:\/\/www.db2tutorial.com\/#website","url":"https:\/\/www.db2tutorial.com\/","name":"DB2 Tutorial","description":"A Comprehensive DB2 Tutorial","publisher":{"@id":"https:\/\/www.db2tutorial.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.db2tutorial.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.db2tutorial.com\/#organization","name":"Db2 Tutorial","url":"https:\/\/www.db2tutorial.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/","url":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png","contentUrl":"https:\/\/db2tutorial.com\/wp-content\/uploads\/2019\/03\/favicon.png","width":500,"height":500,"caption":"Db2 Tutorial"},"image":{"@id":"https:\/\/www.db2tutorial.com\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/comments?post=313"}],"version-history":[{"count":2,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/313\/revisions"}],"predecessor-version":[{"id":1089,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/313\/revisions\/1089"}],"up":[{"embeddable":true,"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/pages\/141"}],"wp:attachment":[{"href":"https:\/\/www.db2tutorial.com\/wp-json\/wp\/v2\/media?parent=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}