{"id":2080,"date":"2025-09-12T11:15:06","date_gmt":"2025-09-12T11:15:06","guid":{"rendered":"https:\/\/itxperts.co.in\/blog\/?p=2080"},"modified":"2026-01-11T07:17:23","modified_gmt":"2026-01-11T07:17:23","slug":"mysql-joins-class-12-notes-examples-questions","status":"publish","type":"post","link":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/","title":{"rendered":"MySQL Joins \u2013 Class 12 Informatics Practices \/ Computer Science Notes"},"content":{"rendered":"\n<p>Relational databases store data in multiple tables. Often, we need to retrieve data from more than one table at the same time. Joins in MySQL allow us to combine rows from two or more tables based on a related column.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Key Concepts of Joins<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Definition<\/strong>:<br>A join is used to fetch data from two or more tables based on a related column (usually a primary key in one table and a foreign key in another).<\/li>\n\n\n\n<li><strong>Why Use Joins?<\/strong>\n<ul class=\"wp-block-list\">\n<li>To avoid redundancy of data in a single table.<\/li>\n\n\n\n<li>To make databases normalized (divided into smaller logical tables).<\/li>\n\n\n\n<li>To fetch meaningful combined information from multiple tables.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Syntax of Join<\/strong>: <code>SELECT table1.column, table2.column FROM table1 JOIN table2 ON table1.common_column = table2.common_column;<\/code><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Types of Joins in MySQL<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. INNER JOIN<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Returns only the rows that have matching values in both tables.<\/li>\n\n\n\n<li>Excludes unmatched rows.<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<p><strong>Students Table<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>RollNo<\/th><th>Name<\/th><th>Class<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Rahul<\/td><td>12A<\/td><\/tr><tr><td>2<\/td><td>Priya<\/td><td>12B<\/td><\/tr><tr><td>3<\/td><td>Amit<\/td><td>12A<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Marks Table<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>RollNo<\/th><th>Subject<\/th><th>Marks<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>CS<\/td><td>90<\/td><\/tr><tr><td>2<\/td><td>CS<\/td><td>85<\/td><\/tr><tr><td>4<\/td><td>CS<\/td><td>75<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Students.RollNo, Students.Name, Marks.Marks\nFROM Students\nINNER JOIN Marks\nON Students.RollNo = Marks.RollNo;\n<\/code><\/pre>\n\n\n\n<p><strong>Result:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>RollNo<\/th><th>Name<\/th><th>Marks<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Rahul<\/td><td>90<\/td><\/tr><tr><td>2<\/td><td>Priya<\/td><td>85<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">2. LEFT JOIN (LEFT OUTER JOIN)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Returns all rows from the left table and matching rows from the right table.<\/li>\n\n\n\n<li>If there is no match, NULL is returned for right table columns.<\/li>\n<\/ul>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Students.RollNo, Students.Name, Marks.Marks\nFROM Students\nLEFT JOIN Marks\nON Students.RollNo = Marks.RollNo;\n<\/code><\/pre>\n\n\n\n<p><strong>Result:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>RollNo<\/th><th>Name<\/th><th>Marks<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Rahul<\/td><td>90<\/td><\/tr><tr><td>2<\/td><td>Priya<\/td><td>85<\/td><\/tr><tr><td>3<\/td><td>Amit<\/td><td>NULL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">3. RIGHT JOIN (RIGHT OUTER JOIN)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Returns all rows from the right table and matching rows from the left table.<\/li>\n\n\n\n<li>If there is no match, NULL is returned for left table columns.<\/li>\n<\/ul>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Students.RollNo, Students.Name, Marks.Marks\nFROM Students\nRIGHT JOIN Marks\nON Students.RollNo = Marks.RollNo;\n<\/code><\/pre>\n\n\n\n<p><strong>Result:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>RollNo<\/th><th>Name<\/th><th>Marks<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Rahul<\/td><td>90<\/td><\/tr><tr><td>2<\/td><td>Priya<\/td><td>85<\/td><\/tr><tr><td>4<\/td><td>NULL<\/td><td>75<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">4. CROSS JOIN (CARTESIAN JOIN)<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Returns all possible combinations of rows between two tables.<\/li>\n\n\n\n<li>If one table has 3 rows and another has 4 rows \u2192 Result = 3 \u00d7 4 = 12 rows.<\/li>\n<\/ul>\n\n\n\n<p><strong>Query:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Students.Name, Marks.Subject\nFROM Students\nCROSS JOIN Marks;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">5. SELF JOIN<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A table is joined with itself (as if it were two tables).<\/li>\n\n\n\n<li>Used for hierarchical data or comparing rows within the same table.<\/li>\n<\/ul>\n\n\n\n<p><strong>Example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT A.Name AS Student1, B.Name AS Student2, A.Class\nFROM Students A, Students B\nWHERE A.Class = B.Class AND A.RollNo &lt; B.RollNo;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Key Points to Remember<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>INNER JOIN \u2192 Only matching rows.<\/li>\n\n\n\n<li>LEFT JOIN \u2192 All rows from left + matched from right.<\/li>\n\n\n\n<li>RIGHT JOIN \u2192 All rows from right + matched from left.<\/li>\n\n\n\n<li>CROSS JOIN \u2192 Cartesian product.<\/li>\n\n\n\n<li>SELF JOIN \u2192 Table with itself.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Practice Questions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Short Answer \/ Theory Questions<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Define a JOIN in MySQL with an example.<\/li>\n\n\n\n<li>Differentiate between INNER JOIN and OUTER JOIN.<\/li>\n\n\n\n<li>Which join will return unmatched rows also? Explain with an example.<\/li>\n\n\n\n<li>Write SQL query to fetch all students with their marks, including those who do not have marks yet.<\/li>\n\n\n\n<li>What is the difference between LEFT JOIN and RIGHT JOIN?<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Query-based Questions<\/h3>\n\n\n\n<p>Given the tables:<\/p>\n\n\n\n<p><strong>Employee Table<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>EID<\/th><th>Name<\/th><th>DeptID<\/th><\/tr><\/thead><tbody><tr><td>101<\/td><td>Ramesh<\/td><td>10<\/td><\/tr><tr><td>102<\/td><td>Suresh<\/td><td>20<\/td><\/tr><tr><td>103<\/td><td>Priya<\/td><td>30<\/td><\/tr><tr><td>104<\/td><td>Aman<\/td><td>NULL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Department Table<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>DeptID<\/th><th>DeptName<\/th><\/tr><\/thead><tbody><tr><td>10<\/td><td>HR<\/td><\/tr><tr><td>20<\/td><td>Accounts<\/td><\/tr><tr><td>40<\/td><td>IT<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Write queries for:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Display all employees with their department names using INNER JOIN.<\/li>\n\n\n\n<li>Display all employees and their departments (if not assigned, show NULL) using LEFT JOIN.<\/li>\n\n\n\n<li>Display all departments with employees (if no employees, show NULL) using RIGHT JOIN.<\/li>\n\n\n\n<li>List employee names with department names, ensuring all employees are displayed even if they do not belong to a department.<\/li>\n\n\n\n<li>Write a query to get all possible pairs of employees with different IDs from the Employee table itself (using SELF JOIN).<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Higher-Order Thinking Questions<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>A school maintains two tables: Teacher(TID, TName, Subject) and Class(CID, ClassName, TID).\n<ul class=\"wp-block-list\">\n<li>Write a query to display all classes with their teachers (use JOIN).<\/li>\n\n\n\n<li>Write a query to display teachers who are not assigned any class.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A company maintains Project(PID, PName, Budget) and Employee(EID, Name, PID).\n<ul class=\"wp-block-list\">\n<li>Write SQL queries using JOIN to:<br>a) Display employee names with their project names.<br>b) Display projects that have no employees assigned.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Relational databases store data in multiple tables. Often, we need to retrieve data from more than one table at the same time. Joins in MySQL allow us to combine rows from two or more tables based on a related column. Key Concepts of Joins Types of Joins in MySQL 1. INNER JOIN Example: Students Table [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2081,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"googlesitekit_rrm_CAow44u0DA:productID":"","footnotes":""},"categories":[159],"tags":[230,126],"class_list":["post-2080","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn-mysql","tag-joins","tag-mysql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions<\/title>\n<meta name=\"description\" content=\"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions\" \/>\n<meta property=\"og:description\" content=\"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"Itxperts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/itxperts.co.in\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-12T11:15:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-11T07:17:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"@mritxperts\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"@mritxperts\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\"},\"author\":{\"name\":\"@mritxperts\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\"},\"headline\":\"MySQL Joins \u2013 Class 12 Informatics Practices \/ Computer Science Notes\",\"datePublished\":\"2025-09-12T11:15:06+00:00\",\"dateModified\":\"2026-01-11T07:17:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\"},\"wordCount\":567,\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png\",\"keywords\":[\"Joins\",\"mysql\"],\"articleSection\":[\"Learn MySQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\",\"name\":\"MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions\",\"isPartOf\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png\",\"datePublished\":\"2025-09-12T11:15:06+00:00\",\"dateModified\":\"2026-01-11T07:17:23+00:00\",\"description\":\"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.\",\"breadcrumb\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png\",\"width\":1536,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itxperts.co.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Joins \u2013 Class 12 Informatics Practices \/ Computer Science Notes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#website\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"name\":\"Itxperts\",\"description\":\"Leading Website Design Company in Madhya Pradesh\",\"publisher\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\"},\"alternateName\":\"Itxperts | Website Development in Madhya Pradesh\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#organization\",\"name\":\"Itxperts\",\"alternateName\":\"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts\",\"url\":\"https:\/\/itxperts.co.in\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"contentUrl\":\"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png\",\"width\":512,\"height\":512,\"caption\":\"Itxperts\"},\"image\":{\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/itxperts.co.in\",\"https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/\",\"https:\/\/www.instagram.com\/itxperts.co.in\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6\",\"name\":\"@mritxperts\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g\",\"caption\":\"@mritxperts\"},\"description\":\"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.\",\"sameAs\":[\"https:\/\/itxperts.co.in\/blog\"],\"url\":\"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions","description":"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.","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:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions","og_description":"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.","og_url":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/","og_site_name":"Itxperts","article_publisher":"https:\/\/www.facebook.com\/itxperts.co.in","article_published_time":"2025-09-12T11:15:06+00:00","article_modified_time":"2026-01-11T07:17:23+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png","type":"image\/png"}],"author":"@mritxperts","twitter_card":"summary_large_image","twitter_misc":{"Written by":"@mritxperts","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#article","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/"},"author":{"name":"@mritxperts","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6"},"headline":"MySQL Joins \u2013 Class 12 Informatics Practices \/ Computer Science Notes","datePublished":"2025-09-12T11:15:06+00:00","dateModified":"2026-01-11T07:17:23+00:00","mainEntityOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/"},"wordCount":567,"publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png","keywords":["Joins","mysql"],"articleSection":["Learn MySQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/","url":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/","name":"MySQL Joins \u2013 Class 12 Informatics Practices Notes with Examples and Questions","isPartOf":{"@id":"https:\/\/itxperts.co.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png","datePublished":"2025-09-12T11:15:06+00:00","dateModified":"2026-01-11T07:17:23+00:00","description":"CBSE Class 12 notes on MySQL Joins with detailed explanations, examples, and practice questions. Covers INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN, and SELF JOIN for exams and practical learning.","breadcrumb":{"@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#primaryimage","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/09\/MYSQL-Joins.png","width":1536,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/itxperts.co.in\/blog\/mysql-joins-class-12-notes-examples-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itxperts.co.in\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Joins \u2013 Class 12 Informatics Practices \/ Computer Science Notes"}]},{"@type":"WebSite","@id":"https:\/\/itxperts.co.in\/blog\/#website","url":"https:\/\/itxperts.co.in\/blog\/","name":"Itxperts","description":"Leading Website Design Company in Madhya Pradesh","publisher":{"@id":"https:\/\/itxperts.co.in\/blog\/#organization"},"alternateName":"Itxperts | Website Development in Madhya Pradesh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itxperts.co.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/itxperts.co.in\/blog\/#organization","name":"Itxperts","alternateName":"Leading Website Design Company in Madhya Pradesh \u2013 Itxperts","url":"https:\/\/itxperts.co.in\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","contentUrl":"https:\/\/itxperts.co.in\/blog\/wp-content\/uploads\/2025\/05\/cropped-itxperts_logo.png","width":512,"height":512,"caption":"Itxperts"},"image":{"@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/itxperts.co.in","https:\/\/www.linkedin.com\/company\/itxpertsshivpuri\/","https:\/\/www.instagram.com\/itxperts.co.in\/"]},{"@type":"Person","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/77ad4d47f9f82583ee23e37010a52fc6","name":"@mritxperts","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itxperts.co.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/702cffafd84d85872c0d42d33a9fa39140418d7c60a1311a1f8f55b005d0570b?s=96&d=mm&r=g","caption":"@mritxperts"},"description":"I am a full-stack web developer from India with over 8 years of experience in building dynamic and responsive web solutions. Specializing in both front-end and back-end development, I have a passion for creating seamless digital experiences. When I'm not coding, I enjoy sharing insights and tutorials on the latest web technologies, helping fellow developers stay ahead in the ever-evolving tech landscape.","sameAs":["https:\/\/itxperts.co.in\/blog"],"url":"https:\/\/itxperts.co.in\/blog\/author\/mritxpertsgmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/comments?post=2080"}],"version-history":[{"count":1,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2080\/revisions"}],"predecessor-version":[{"id":2082,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/posts\/2080\/revisions\/2082"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media\/2081"}],"wp:attachment":[{"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/media?parent=2080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/categories?post=2080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itxperts.co.in\/blog\/wp-json\/wp\/v2\/tags?post=2080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}