{"id":105473,"date":"2021-10-25T11:00:00","date_gmt":"2021-10-25T08:00:00","guid":{"rendered":"https:\/\/examples.javacodegeeks.com\/?p=105473"},"modified":"2021-10-25T02:33:17","modified_gmt":"2021-10-24T23:33:17","slug":"sql-full-join-statement","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/","title":{"rendered":"SQL FULL JOIN Statement"},"content":{"rendered":"<p>Hello. In this tutorial, we will learn the SQL FULL JOIN keyword.<\/p>\n<h2>1. Introduction<\/h2>\n<p><strong>SQL<\/strong> stands for <em>Structured Query Language<\/em> and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be used later for analysis. In real-time SQL manages a large amount of data that is written and read simultaneously and any query that reaches the SQL server is processed into three parts \u2013<\/p>\n<ul>\n<li><em>Parsing<\/em> \u2013 Process to check the SQL query syntax<\/li>\n<li><em>Binding<\/em> \u2013 Process to check the SQL query semantics<\/li>\n<li><em>Optimization<\/em> \u2013 Process to generate the SQL query execution plan<\/li>\n<\/ul>\n<h3>1.1 Usage of SQL<\/h3>\n<p>Structured Query Language (popularly known as <em>SQL<\/em>) is commonly used by data analysts and data science professionals and is helpful too \u2013<\/p>\n<ul>\n<li>Execute queries against the database<\/li>\n<li>Retrieve data from the database<\/li>\n<li>Insert new records into the database<\/li>\n<li>Update existing records into the database<\/li>\n<li>Created stored procedures, functions, and materialized views in the database<\/li>\n<li>Create users and grant permissions<\/li>\n<li>Set permissions on tables, stored procedures, functions, and materialized views<\/li>\n<\/ul>\n<h3>1.2 SQL FULL JOIN statement<\/h3>\n<p>The <strong>SQL FULL JOIN<\/strong> statement returns all records from both tables. This keyword will \u2013<\/p>\n<ul>\n<li>Return column with a NULL value for non-matching rows<\/li>\n<li>Can return a large result set<\/li>\n<li>Represented by the syntax &#8211; <code>SELECT * FROM table1 FULL JOIN table2 ON table1.column_name = table2.column_name;<\/code><\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/sqlfulljoin-imgguide1.jpg\"><img decoding=\"async\" width=\"406\" height=\"157\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/sqlfulljoin-imgguide1.jpg\" alt=\"sql full join - venn diagram\" class=\"wp-image-105474\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/sqlfulljoin-imgguide1.jpg 406w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/sqlfulljoin-imgguide1-300x116.jpg 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/a><figcaption>Fig. 1: SQL FULL JOIN Venn Diagram<\/figcaption><\/figure>\n<\/div>\n<h2>2. SQL FULL JOIN statement<\/h2>\n<p>Let us dive into some practice implementation.<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<h3>2.1 Postgres Setup<\/h3>\n<p>Usually, setting up the database is a tedious step but with the technological advancements, this process has become simple with the help of <a href=\"https:\/\/www.docker.com\/\" target=\"_blank\" rel=\"noopener\">Docker<\/a>. Readers can watch the video available at this <a href=\"https:\/\/www.youtube.com\/watch?v=S7NVloq0EBc\" target=\"_blank\" rel=\"noopener\">link<\/a> to understand the Docker installation on Windows OS. Open the terminal and trigger the following commands to get the PostgreSQL up and running on the local machine.<\/p>\n<pre class=\"brush:plain; wrap-lines:false;\">-- command to run postgres on docker\ndocker run -d -p 5433:5432 -e POSTGRES_PASSWORD= --name postgres postgres\n\n-- command to stop the Postgres docker container\ndocker stop postgres\n\n-- command to remove the Postgres docker container\ndocker rm postgres\n<\/pre>\n<p>Remember to enter the password of your choice. If everything goes well the PostgreSQL database server would be up and running on a port number \u2013 <code>5433<\/code>.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/dockerpostgresrun-2.jpg\"><img decoding=\"async\" width=\"818\" height=\"133\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/dockerpostgresrun-2.jpg\" alt=\"sql full join - postgres on docker\" class=\"wp-image-105475\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/dockerpostgresrun-2.jpg 818w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/dockerpostgresrun-2-300x49.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/dockerpostgresrun-2-768x125.jpg 768w\" sizes=\"(max-width: 818px) 100vw, 818px\" \/><\/a><figcaption>Fig. 2. Postgres on Docker<\/figcaption><\/figure>\n<\/div>\n<h3>2.2 Creating a Sample database<\/h3>\n<p>To implement this tutorial I am using the sample database provided below.<\/p>\n<p><span style=\"text-decoration: underline\"><em>SQL Script<\/em><\/span><\/p>\n<pre class=\"brush:sql; wrap-lines:false;\">-- employee table and data --\ncreate table employee\n(\n    id SERIAL PRIMARY KEY,\n    first_name VARCHAR(50),\n    last_name VARCHAR(50),\n    email VARCHAR(50) NOT NULL,\n    gender VARCHAR(50)\n);\n\ninsert into employee(first_name, last_name, email, gender)\nvalues('Rice', 'Cristou', 'rcristou0@usa.gov', 'Female');\ninsert into employee(first_name, last_name, email, gender)\nvalues('Delia', 'Jarrold', 'djarrold1@altervista.org', 'Male');\ninsert into employee(first_name, last_name, email, gender)\nvalues('Zorine', 'Onions', 'zonions2@dagondesign.com', 'Female');\ninsert into employee(first_name, last_name, email, gender)\nvalues('Kelley', 'Kleis', 'kkleis3@adobe.com', 'Female');\ninsert into employee(first_name, last_name, email, gender)\nvalues('Reece', 'Petrushanko', 'rpetrushanko4@ihg.com', 'Male');\ninsert into employee(first_name, last_name, email, gender)\nvalues('John', 'Doe', 'johndoe01@ihg.com', 'Male');\n\nselect * from employee;\n\n-- department table and data --\ncreate table department\n(\n    id SERIAL PRIMARY KEY,\n    emp_id int,\n    name VARCHAR(50) NOT NULL\n);\n\ninsert into department(emp_id, name)values(1, 'Sales');\ninsert into department(emp_id, name)values(2, 'Product Management');\ninsert into department(emp_id, name)values(3, 'Research and Development');\ninsert into department(emp_id, name)values(4, 'Training');\ninsert into department(emp_id, name)values(5, 'Business Development');\ninsert into department(emp_id, name)values(NULL, 'Accounting');\ninsert into department(emp_id, name)values(NULL, 'Human Resources');\n\nselect * from department;\n<\/pre>\n<p>The database is available for download at this <a href=\"https:\/\/www.postgresqltutorial.com\/postgresql-sample-database\/\">link<\/a> and can be easily imported into the existing database of your choice.<\/p>\n<h4>2.3 Executing basic SQL commands<\/h4>\n<p>You can use the following SQL commands to practice the SQL joins.<\/p>\n<ul>\n<li>The first query will return all the rows from both tables. For the non-matching rows, the column value will be populated with <code>null<\/code><\/li>\n<li>In the second query, we will have the WHERE clause to find the departments that have no employees assigned<\/li>\n<\/ul>\n<p><span style=\"text-decoration: underline\"><em>SQL Script<\/em><\/span><\/p>\n<pre class=\"brush:sql; wrap-lines:false;\">-- full join --\nselect e.first_name,\n       e.last_name,\n       d.name as department_name\nfrom employee e\n    full join department d\n        on e.id = d.emp_id;\n\n-- full join with where clause --\nselect e.first_name,\n       e.last_name,\n       d.name as department_name\nfrom employee e\n    full join department d\n        on e.id = d.emp_id\nwhere e.first_name is null\n      and e.last_name is null;\n<\/pre>\n<h2>3. Summary<\/h2>\n<p>In this tutorial, we learned the basics of the SQL FULL JOIN keyword and basic query implementation. You can download the sql scripts from the <a href=\"#projectDownload\">Downloads<\/a> section.<\/p>\n<h2><a name=\"projectDownload\"><\/a>4. Download the Scripts<\/h2>\n<p>This was a tutorial on learning the SQL FULL JOIN statement.<\/p>\n<div class=\"download\"><strong>Download<\/strong><br \/>You can download the full source code of this example here: <a href=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2021\/10\/SQL-FULL-JOIN-Statement.zip\"><strong>SQL FULL JOIN Keyword<\/strong><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and organize data stored in relational databases like MySQL, PostgreSQL, Oracle, etc. A relational database consists of rows and columns that allow fetching specific information from databases that can be &hellip;<\/p>\n","protected":false},"author":119,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[1055],"class_list":["post-105473","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL FULL JOIN Statement - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL FULL JOIN Statement - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-25T08:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Yatin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yatin\" \/>\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:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\"},\"author\":{\"name\":\"Yatin\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/9874407a37b028e8be3276e2b5960d13\"},\"headline\":\"SQL FULL JOIN Statement\",\"datePublished\":\"2021-10-25T08:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\"},\"wordCount\":488,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"sql\"],\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\",\"name\":\"SQL FULL JOIN Statement - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2021-10-25T08:00:00+00:00\",\"description\":\"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"SQL FULL JOIN Statement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/9874407a37b028e8be3276e2b5960d13\",\"name\":\"Yatin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2023\/09\/cropped-Yatin-Batra_avatar_1515758148-96x96.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2023\/09\/cropped-Yatin-Batra_avatar_1515758148-96x96.jpg\",\"caption\":\"Yatin\"},\"description\":\"An experience full-stack engineer well versed with Core Java, Spring\/Springboot, MVC, Security, AOP, Frontend (Angular &amp; React), and cloud technologies (such as AWS, GCP, Jenkins, Docker, K8).\",\"sameAs\":[\"https:\/\/www.javacodegeeks.com\"],\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/yatin-batra\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL FULL JOIN Statement - Java Code Geeks","description":"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and","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:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/","og_locale":"en_US","og_type":"article","og_title":"SQL FULL JOIN Statement - Java Code Geeks","og_description":"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and","og_url":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2021-10-25T08:00:00+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Yatin","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Yatin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/"},"author":{"name":"Yatin","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/9874407a37b028e8be3276e2b5960d13"},"headline":"SQL FULL JOIN Statement","datePublished":"2021-10-25T08:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/"},"wordCount":488,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["sql"],"articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/","url":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/","name":"SQL FULL JOIN Statement - Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2021-10-25T08:00:00+00:00","description":"Hello. In this tutorial, we will learn the SQL FULL JOIN keyword. 1. Introduction SQL stands for Structured Query Language and is used to extract and","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/sql-full-join-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"SQL FULL JOIN Statement"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/9874407a37b028e8be3276e2b5960d13","name":"Yatin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2023\/09\/cropped-Yatin-Batra_avatar_1515758148-96x96.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2023\/09\/cropped-Yatin-Batra_avatar_1515758148-96x96.jpg","caption":"Yatin"},"description":"An experience full-stack engineer well versed with Core Java, Spring\/Springboot, MVC, Security, AOP, Frontend (Angular &amp; React), and cloud technologies (such as AWS, GCP, Jenkins, Docker, K8).","sameAs":["https:\/\/www.javacodegeeks.com"],"url":"https:\/\/examples.javacodegeeks.com\/author\/yatin-batra\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/105473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/119"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=105473"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/105473\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=105473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=105473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=105473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}