{"id":14707,"date":"2023-03-21T14:00:14","date_gmt":"2023-03-21T14:00:14","guid":{"rendered":"https:\/\/www.prepbytes.com\/blog\/?p=14707"},"modified":"2023-12-27T05:19:18","modified_gmt":"2023-12-27T05:19:18","slug":"joins-in-dbms","status":"publish","type":"post","link":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/","title":{"rendered":"Joins in DBMS"},"content":{"rendered":"<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\" alt=\"\" \/><\/p>\n<p>Welcome to the comprehensive guide on Joins in Database Management Systems (DBMS). Joins are fundamental operations in DBMS that allow the combination of data from multiple tables based on a related column between them. They play a crucial role in querying databases efficiently and retrieving meaningful insights from interconnected data.<\/p>\n<p>In this article, we&#8217;ll delve into the various types of joins, their functionalities, syntax, and common use cases. Whether you&#8217;re a beginner looking to understand the basics or an experienced professional seeking a refresher, this guide aims to provide you with a solid understanding of joins in DBMS.<\/p>\n<h2>What are Joins in DBMS?<\/h2>\n<p>A join is a way to combine data from two or more tables based on a common column. For example, let&#8217;s say we have two tables: Customers and Orders. The Customers table contains information about each customer, including their name, address, and email address. The Orders table contains information about each order, including the order date, product name, and quantity.<\/p>\n<p>To combine data from these two tables, we can join them on the customer ID column, which is common to both tables. By doing so, we can retrieve information about each customer&#8217;s orders in a single query.<\/p>\n<h2>Types of Joins in DBMS<\/h2>\n<p>There are several types of joins in DBMS, each with its own syntax and use case. The following are the different types of Joins in DBMS.<\/p>\n<ul>\n<li>Inner Join\n<ul>\n<li>Theta Join<\/li>\n<li>Equi Join<\/li>\n<\/ul>\n<\/li>\n<li>Natural Join<\/li>\n<li>Outer Join\n<ul>\n<li>Left Outer Join<\/li>\n<li>Right Outer Join<\/li>\n<li>Full Outer Join<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>We will understand all of these joins in DBMS with the help of the following tables.<\/p>\n<p><strong>Table1:<\/strong><\/p>\n<table>\n<thead>\n<tr>\n<th>ID<\/th>\n<th>Name<\/th>\n<th>Age<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Alice<\/td>\n<td>23<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Bob<\/td>\n<td>28<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Charlie<\/td>\n<td>32<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Table2:<\/strong><\/p>\n<table>\n<thead>\n<tr>\n<th>ID<\/th>\n<th>Address<\/th>\n<th>Salary<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>2<\/td>\n<td>New York<\/td>\n<td>50000<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Boston<\/td>\n<td>65000<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>San Diego<\/td>\n<td>75000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Inner Join<\/h3>\n<p>An Inner Join returns only the rows in both tables that match the join condition.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619791-1-01%20%285%29.png\" alt=\"\" \/><\/p>\n<p><strong>Theta Join<\/strong><br \/>\nA Theta Join uses a condition other than equality to join two tables. It uses operators like , =, , etc., to define the join condition.<\/p>\n<p><strong>Syntax of Theta Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nINNER JOIN table2\nON table1.columnX operator table2.columnY;<\/code><\/pre>\n<p><strong>Example of Theta Join<\/strong><br \/>\nConsider the above two tables.<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform a Theta Join, we can join the two tables on the condition that the age in Table1 is greater than the salary in Table2.<\/p>\n<pre><code>SELECT Table1.Name, Table2.Address\nFROM Table1\nINNER JOIN Table2\nON Table1.Age &gt; Table2.Salary;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th><strong>Name<\/strong><\/th>\n<th><strong>Address<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<\/tbody>\n<\/table>\n<p>Here we get an empty table as a result because not a single entry is following the condition specified in the join<\/p>\n<p><strong>Equi Join<\/strong><br \/>\nAn Equi Join returns all the rows in both tables where the specified<br \/>\ncolumns are equal.<\/p>\n<p><strong>Syntax of Equi Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nINNER JOIN table2\nON table1.columnX = table2.columnY;<\/code><\/pre>\n<p><strong>Example of Equi Join<\/strong><br \/>\nTaking reference from the above tables, table 1 and table 2.<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform an Equi Join, we can join the two tables on the ID column.<\/p>\n<pre><code>SELECT Table1.Name, Table2.Address\nFROM Table1\nINNER JOIN Table2\nON Table1.ID = Table2.ID;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th>Name<\/th>\n<th>Address<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Bob<\/td>\n<td>New York<\/td>\n<\/tr>\n<tr>\n<td>Charlie<\/td>\n<td>Boston<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Natural Join<\/h3>\n<p>A Natural Join is a type of Join that matches columns with the same name in both tables.<\/p>\n<p><strong>Syntax of Natural Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nNATURAL JOIN table2;<\/code><\/pre>\n<p><strong>Example of Natural Join<\/strong><br \/>\nConsider the above two tables:<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform a Natural Join, we can simply use the following query:<\/p>\n<pre><code>SELECT Table1.ID, Table1.Name, Table1.Age, Table2.Address, Table2.Salary\nFROM Table1\nNATURAL JOIN Table2;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th>ID<\/th>\n<th>Name<\/th>\n<th>Age<\/th>\n<th>Address<\/th>\n<th>Salary<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>2<\/td>\n<td>Bob<\/td>\n<td>28<\/td>\n<td>New York<\/td>\n<td>50000<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Charlie<\/td>\n<td>32<\/td>\n<td>Boston<\/td>\n<td>65000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Outer Join<\/h3>\n<p>An Outer Join in DBMS returns all the rows from one table and the matching rows from the other table. If there is no match, NULL values are returned for the missing rows.<\/p>\n<p><strong>Left Outer Join<\/strong><br \/>\nA Left Outer Join in DBMS returns all the rows from the left table and the matching rows from the right table. If there is no match, NULL values are returned for the missing rows.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619792-1-02%20%284%29.png\" alt=\"\" \/><\/p>\n<p><strong>Syntax of Left Outer Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nLEFT JOIN table2\nON table1.columnX = table2.columnY;<\/code><\/pre>\n<p><strong>Example of Left Outer Join<\/strong><br \/>\nAgain Considering the above two tables:<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform a Left Outer Join, we can join the two tables on the ID column.<\/p>\n<pre><code>SELECT Table1.Name, Table2.Address\nFROM Table1\nLEFT JOIN Table2\nON Table1.ID = Table2.ID;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th>Name<\/th>\n<th>Address<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Alice<\/td>\n<td>NULL<\/td>\n<\/tr>\n<tr>\n<td>Bob<\/td>\n<td>New York<\/td>\n<\/tr>\n<tr>\n<td>Charlie<\/td>\n<td>Boston<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Right Outer Join<\/strong><br \/>\nA Right Outer Join returns all the rows from the right table and the matching rows from the left table. If there is no match, NULL values are returned for the missing rows.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619797-1-03%20%282%29.png\" alt=\"\" \/><\/p>\n<p><strong>Syntax of Right Outer Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nRIGHT JOIN table2\nON table1.columnX = table2.columnY;<\/code><\/pre>\n<p><strong>Example of Right Outer Join<\/strong><br \/>\nConsider the above two tables:<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform a Right Outer Join, we can join the two tables on the ID column.<\/p>\n<pre><code>SELECT Table1.Name, Table2.Address\nFROM Table1\nRIGHT JOIN Table2\nON Table1.ID = Table2.ID;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th>Name<\/th>\n<th>Address<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Bob<\/td>\n<td>New York<\/td>\n<\/tr>\n<tr>\n<td>Charlie<\/td>\n<td>Boston<\/td>\n<\/tr>\n<tr>\n<td>NULL<\/td>\n<td>San Diego<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Full Outer Join<\/strong><br \/>\nA Full Outer Join returns all the rows from both tables and NULL values for the missing rows.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619797-1-04%20%282%29.png\" alt=\"\" \/><\/p>\n<p><strong>Syntax of Full Outer Join<\/strong><\/p>\n<pre><code>SELECT table1.column1, table2.column2\nFROM table1\nFULL OUTER JOIN table2\nON table1.columnX = table2.columnY;<\/code><\/pre>\n<p><strong>Example of Full Outer Join<\/strong><br \/>\nConsidering the above-mentioned two tables i.e., Table1 and Table2:<\/p>\n<p><strong>Query:<\/strong><br \/>\nTo perform a Full Outer Join, we can join the two tables on the ID column.<\/p>\n<pre><code>SELECT Table1.Name, Table2.Address\nFROM Table1\nFULL OUTER JOIN Table2\nON Table1.ID = Table2.ID;<\/code><\/pre>\n<p><strong>Output:<\/strong><br \/>\nThis query would return the following result:<\/p>\n<table>\n<thead>\n<tr>\n<th>Name<\/th>\n<th>Address<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Alice<\/td>\n<td>NULL<\/td>\n<\/tr>\n<tr>\n<td>Bob<\/td>\n<td>New York<\/td>\n<\/tr>\n<tr>\n<td>Charlie<\/td>\n<td>Boston<\/td>\n<\/tr>\n<tr>\n<td>NULL<\/td>\n<td>San Diego<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>A Quick Revision of Joins in DBMS<\/h2>\n<p>To assist you in a good revision, a quick revision on Joins in DBMS is given below:<\/p>\n<ul>\n<li>Joins in DBMS is used to combine tables.<\/li>\n<li>There are three types of joins: inner joins, natural joins, and outer joins.<\/li>\n<li>Inner joins are classified into two types: Theta Join(for relational operators) and Equi Join(for Equality).<\/li>\n<li>There are three types of outer joins in DBMS: left outer join, right outer join, and full outer join.<\/li>\n<li>Natural join is only performed when at least one matching attribute exists in both tables.<\/li>\n<li>No matter the Join condition, a left outer join always returns every row from the left table.<\/li>\n<li>Regardless of the Join condition, Right Outer Join always returns all rows from the right table.<\/li>\n<li>Regardless of the join condition, Complete Outer Join always returns all rows from both tables.<\/li>\n<\/ul>\n<p><strong>Conclusion<\/strong><br \/>\nIn conclusion, joins are an indispensable aspect of working with relational databases. They enable the amalgamation of data spread across different tables, facilitating the extraction of valuable information and insights. By comprehending the types of joins available\u2014such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN\u2014and their applications, database administrators and developers can optimize query performance, ensure data accuracy, and derive meaningful results.<\/p>\n<p>Remember, mastering the art of utilizing joins effectively involves a combination of theoretical knowledge and practical application. With continuous practice and exploration, one can leverage joins efficiently to handle complex data scenarios in DBMS, thereby enhancing the efficiency and productivity of database-related tasks<\/p>\n<h2>FAQs Related to Joins in DBMS<\/h2>\n<p>Some Frequently Asked Questions on Joins in DBMS are given below.<\/p>\n<p><strong>Q1. What is the difference between Inner Join and Outer Join?<\/strong><br \/>\nThe main difference between Inner Join and Outer Join is that Inner Join returns only the matching records from both tables, while Outer Join returns all records from one table and matching records from the other table.<\/p>\n<p><strong>Q2: What are the different types of joins in DBMS?<\/strong><br \/>\nThe common types of joins in DBMS include:<\/p>\n<ul>\n<li><strong>INNER JOIN:<\/strong> Retrieves records that have matching values in both tables.<\/li>\n<li><strong>LEFT JOIN:<\/strong> Retrieves all records from the left table and matching records from the right table.<\/li>\n<li><strong>RIGHT JOIN:<\/strong> Retrieves all records from the right table and matching records from the left table.<\/li>\n<li><strong>OUTER JOIN:<\/strong> Retrieves all records when there is a match in either the left or right table.<\/li>\n<\/ul>\n<p><strong>Q3: How do joins improve query performance in databases?<\/strong><br \/>\nJoins optimize query performance by minimizing data redundancy, allowing for efficient data retrieval, and facilitating the extraction of specific information from multiple related tables rather than querying each table separately.<\/p>\n<p><strong>Q4: What are some common use cases for joins in DBMS?<\/strong><br \/>\nJoins are commonly used for tasks such as generating reports, analyzing data from multiple sources, retrieving information for business intelligence, and creating complex data views to support decision-making processes.<\/p>\n<p><strong>Q5: Are there any limitations or challenges associated with using joins in DBMS?<\/strong><br \/>\nWhile joins are powerful, they can lead to performance issues with large datasets or complex queries. Additionally, improper usage or excessive joins in a query can result in slower execution times and increased resource consumption. It&#8217;s crucial to optimize queries and understand the database schema to mitigate these challenges.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the comprehensive guide on Joins in Database Management Systems (DBMS). Joins are fundamental operations in DBMS that allow the combination of data from multiple tables based on a related column between them. They play a crucial role in querying databases efficiently and retrieving meaningful insights from interconnected data. In this article, we&#8217;ll delve [&hellip;]<\/p>\n","protected":false},"author":52,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[190],"tags":[],"class_list":["post-14707","post","type-post","status-publish","format-standard","hentry","category-dbms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Types of Joins in DBMS with Each Syntax and Example<\/title>\n<meta name=\"description\" content=\"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Types of Joins in DBMS with Each Syntax and Example\" \/>\n<meta property=\"og:description\" content=\"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\" \/>\n<meta property=\"og:site_name\" content=\"PrepBytes Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prepbytes0211\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-21T14:00:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-27T05:19:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\" \/>\n<meta name=\"author\" content=\"Prepbytes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prepbytes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\"},\"author\":{\"name\":\"Prepbytes\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e\"},\"headline\":\"Joins in DBMS\",\"datePublished\":\"2023-03-21T14:00:14+00:00\",\"dateModified\":\"2023-12-27T05:19:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\"},\"wordCount\":1359,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\",\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\",\"url\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\",\"name\":\"Types of Joins in DBMS with Each Syntax and Example\",\"isPartOf\":{\"@id\":\"http:\/\/43.205.93.38\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\",\"datePublished\":\"2023-03-21T14:00:14+00:00\",\"dateModified\":\"2023-12-27T05:19:18+00:00\",\"description\":\"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.\",\"breadcrumb\":{\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage\",\"url\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\",\"contentUrl\":\"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/43.205.93.38\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBMS\",\"item\":\"https:\/\/prepbytes.com\/blog\/category\/dbms\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Joins in DBMS\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/43.205.93.38\/#website\",\"url\":\"http:\/\/43.205.93.38\/\",\"name\":\"PrepBytes Blog\",\"description\":\"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING\",\"publisher\":{\"@id\":\"http:\/\/43.205.93.38\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/43.205.93.38\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/43.205.93.38\/#organization\",\"name\":\"Prepbytes\",\"url\":\"http:\/\/43.205.93.38\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"contentUrl\":\"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp\",\"width\":160,\"height\":160,\"caption\":\"Prepbytes\"},\"image\":{\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/prepbytes0211\/\",\"https:\/\/www.instagram.com\/prepbytes\/\",\"https:\/\/www.linkedin.com\/company\/prepbytes\/\",\"https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e\",\"name\":\"Prepbytes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/43.205.93.38\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g\",\"caption\":\"Prepbytes\"},\"url\":\"https:\/\/prepbytes.com\/blog\/author\/gourav-jaincollegedekho-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Types of Joins in DBMS with Each Syntax and Example","description":"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.","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:\/\/prepbytes.com\/blog\/joins-in-dbms\/","og_locale":"en_US","og_type":"article","og_title":"Types of Joins in DBMS with Each Syntax and Example","og_description":"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.","og_url":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/","og_site_name":"PrepBytes Blog","article_publisher":"https:\/\/www.facebook.com\/prepbytes0211\/","article_published_time":"2023-03-21T14:00:14+00:00","article_modified_time":"2023-12-27T05:19:18+00:00","og_image":[{"url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg","type":"","width":"","height":""}],"author":"Prepbytes","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Prepbytes","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#article","isPartOf":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/"},"author":{"name":"Prepbytes","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e"},"headline":"Joins in DBMS","datePublished":"2023-03-21T14:00:14+00:00","dateModified":"2023-12-27T05:19:18+00:00","mainEntityOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/"},"wordCount":1359,"commentCount":0,"publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg","articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/","url":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/","name":"Types of Joins in DBMS with Each Syntax and Example","isPartOf":{"@id":"http:\/\/43.205.93.38\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage"},"image":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage"},"thumbnailUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg","datePublished":"2023-03-21T14:00:14+00:00","dateModified":"2023-12-27T05:19:18+00:00","description":"A join is a way to combine data from two or more tables based on a common column. Several types of joins in DBMS, each with its own syntax and use case.","breadcrumb":{"@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prepbytes.com\/blog\/joins-in-dbms\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#primaryimage","url":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg","contentUrl":"https:\/\/prepbytes-misc-images.s3.ap-south-1.amazonaws.com\/assets\/1679308619703-Joins%20in%20DBMS.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/prepbytes.com\/blog\/joins-in-dbms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/43.205.93.38\/"},{"@type":"ListItem","position":2,"name":"DBMS","item":"https:\/\/prepbytes.com\/blog\/category\/dbms\/"},{"@type":"ListItem","position":3,"name":"Joins in DBMS"}]},{"@type":"WebSite","@id":"http:\/\/43.205.93.38\/#website","url":"http:\/\/43.205.93.38\/","name":"PrepBytes Blog","description":"ONE-STOP RESOURCE FOR EVERYTHING RELATED TO CODING","publisher":{"@id":"http:\/\/43.205.93.38\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/43.205.93.38\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/43.205.93.38\/#organization","name":"Prepbytes","url":"http:\/\/43.205.93.38\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/","url":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","contentUrl":"https:\/\/blog.prepbytes.com\/wp-content\/uploads\/2025\/07\/uzxxllgloialmn9mhwfe.webp","width":160,"height":160,"caption":"Prepbytes"},"image":{"@id":"http:\/\/43.205.93.38\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/prepbytes0211\/","https:\/\/www.instagram.com\/prepbytes\/","https:\/\/www.linkedin.com\/company\/prepbytes\/","https:\/\/www.youtube.com\/channel\/UC0xGnHDrjUM1pDEK2Ka5imA"]},{"@type":"Person","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/3f7dc4ae851791d5947a7f99df363d5e","name":"Prepbytes","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/43.205.93.38\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/232042cd1a1ea0e982c96d2a2ec93fb70a8e864e00784491231e7bfe5a9e06b5?s=96&d=mm&r=g","caption":"Prepbytes"},"url":"https:\/\/prepbytes.com\/blog\/author\/gourav-jaincollegedekho-com\/"}]}},"_links":{"self":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/comments?post=14707"}],"version-history":[{"count":2,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14707\/revisions"}],"predecessor-version":[{"id":18575,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/posts\/14707\/revisions\/18575"}],"wp:attachment":[{"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/media?parent=14707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/categories?post=14707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prepbytes.com\/blog\/wp-json\/wp\/v2\/tags?post=14707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}