{"id":16781,"date":"2020-07-07T09:46:52","date_gmt":"2020-07-07T09:46:52","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16781"},"modified":"2020-07-07T09:46:52","modified_gmt":"2020-07-07T09:46:52","slug":"sql-inner-join-in-oracle-sql-oracle-sql-tutorials-20","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-inner-join-in-oracle-sql-oracle-sql-tutorials-20\/","title":{"rendered":"SQL Inner Join in Oracle SQL | Oracle SQL Tutorials -20"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain SQL Inner Join in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16079\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\" alt=\"\" width=\"387\" height=\"311\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png 387w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial-300x241.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<p align=\"left\"><!--more--><\/p>\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong>Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"eYB3EWzXeM\"><p><a href=\"https:\/\/ittutorial.org\/sql-join-and-join-types-in-oracle-sql-oracle-sql-tutorials-19\/\">SQL Join and Join Types in Oracle SQL | Oracle SQL Tutorials -19<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;SQL Join and Join Types in Oracle SQL | Oracle SQL Tutorials -19&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/sql-join-and-join-types-in-oracle-sql-oracle-sql-tutorials-19\/embed\/#?secret=ygXyw7Adyn#?secret=eYB3EWzXeM\" data-secret=\"eYB3EWzXeM\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">The (INNER) Join<\/span><\/h4>\n<p>Inner Join or only Join keyword is used to list the records when matching values exist in both tables<\/p>\n<p>If you do not specify the join type with words like <strong>inner , right , left<\/strong> in the query , inner join is the <strong>default<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h3>(INNER) JOIN Syntax<\/h3>\n<p>Inner join syntax is as follows. You can use the (INNER) Join with 3 types of syntax as follows.<\/p>\n<p>Using INNER is not necessary, you can skip this clause.<\/p>\n<p>If you want to use INNER Join, you can skip both INNER and Join clause as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column1,column2,column(n)...<\/em>\r\n<strong><span style=\"color: #ff0000;\"><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table1<\/em><\/span><\/strong>\r\n<strong><span style=\"color: #ff0000;\"><span class=\"sqlkeywordcolor\">INNER<\/span>\u00a0<span class=\"sqlkeywordcolor\">JOIN<\/span>\u00a0<\/span><\/strong><em><strong><span style=\"color: #ff0000;\">table2<\/span><\/strong>\r\n<\/em><span class=\"sqlkeywordcolor\">ON<\/span>\u00a0<em>table1.column_name\u00a0<\/em>=<em>\u00a0table2.column_name<\/em>;<\/span><\/pre>\n<div class=\"w3-example\">\n<pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column1,column2,column(n)...<\/em>\r\n<span style=\"color: #ff0000;\"><strong><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table1<\/em><\/strong><\/span>\r\n<span style=\"color: #ff0000;\"><strong><span class=\"sqlkeywordcolor\">JOIN<\/span>\u00a0<\/strong><\/span><em><span style=\"color: #ff0000;\"><strong>table2<\/strong><\/span>\r\n<\/em><span class=\"sqlkeywordcolor\">ON<\/span>\u00a0<em>table1.column_name\u00a0<\/em>=<em>\u00a0table2.column_name<\/em>;\r\n\r\n<span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column1,column2,column(n)...<\/em>\r\n<span style=\"color: #ff0000;\"><strong><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table1,<\/em> <\/strong><\/span><em><span style=\"color: #ff0000;\"><strong>table2<\/strong><\/span>\r\n<\/em><span class=\"sqlkeywordcolor\">where<\/span>\u00a0<em>table1.column_name\u00a0<\/em>=<em>\u00a0table2.column_name<\/em>;\r\n<\/span><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16782\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/inner-join-oracle-sql.jpg\" alt=\"\" width=\"326\" height=\"295\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/inner-join-oracle-sql.jpg 326w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/inner-join-oracle-sql-300x271.jpg 300w\" sizes=\"auto, (max-width: 326px) 100vw, 326px\" \/><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div>You can review the following example. 3 SQL Statements have the same result as follows.<\/div>\n<pre>SQL&gt; select first_name,last_name,DEPARTMENT_NAME from hr.employees e inner join hr.departments d on e.department_id=d.department_id where e.salary&gt;13000;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------------------------\r\nNeena                Kochhar                   Executive\r\nLex                  De Haan                   Executive\r\nNancy                Greenberg                 Finance\r\nJohn                 Russell                   Sales\r\nKaren                Partners                  Sales\r\nMichael              Hartstein                 Marketing\r\nShelley              Higgins                   Accounting\r\n\r\n7 rows selected.\r\n\r\nSQL&gt;  select first_name,last_name,DEPARTMENT_NAME from hr.employees e join hr.departments d on e.department_id=d.department_id where e.salary&gt;13000;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------------------------\r\nNeena                Kochhar                   Executive\r\nLex                  De Haan                   Executive\r\nNancy                Greenberg                 Finance\r\nJohn                 Russell                   Sales\r\nKaren                Partners                  Sales\r\nMichael              Hartstein                 Marketing\r\nShelley              Higgins                   Accounting\r\n\r\n7 rows selected.\r\n\r\nSQL&gt; select first_name,last_name,DEPARTMENT_NAME from hr.employees e,hr.departments d where e.department_id=d.department_id and e.salary&gt;13000;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------------------------\r\nNeena                Kochhar                   Executive\r\nLex                  De Haan                   Executive\r\nNancy                Greenberg                 Finance\r\nJohn                 Russell                   Sales\r\nKaren                Partners                  Sales\r\nMichael              Hartstein                 Marketing\r\nShelley              Higgins                   Accounting\r\n\r\n7 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>Mostly developers don&#8217;t use the Join or Inner Join keyword, they prefer the third usage as follows.<\/p>\n<pre>SQL&gt; select first_name,last_name,DEPARTMENT_NAME from hr.employees e,hr.departments d where e.department_id=d.department_id and e.salary&gt;13000;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------------------------\r\nNeena                Kochhar                   Executive\r\nLex                  De Haan                   Executive\r\nNancy                Greenberg                 Finance\r\nJohn                 Russell                   Sales\r\nKaren                Partners                  Sales\r\nMichael              Hartstein                 Marketing\r\nShelley              Higgins                   Accounting\r\n\r\n7 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>You can use multiple join in a SQL Statement as follows.<\/p>\n<pre>SQL&gt; select first_name,last_name,DEPARTMENT_NAME,JOB_TITLE from hr.employees e inner join hr.departments d on e.department_id=d.department_id join hr.jobs j on e.job_id=j.job_id where e.salary&gt;13000;\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME                JOB_TITLE\r\n-------------------- ------------------------- ------------------------------ -----------------------------------\r\nNeena                Kochhar                   Executive                      Administration Vice President\r\nLex                  De Haan                   Executive                      Administration Vice President\r\nNancy                Greenberg                 Finance                        Finance Manager\r\nJohn                 Russell                   Sales                          Sales Manager\r\nKaren                Partners                  Sales                          Sales Manager\r\nMichael              Hartstein                 Marketing                      Marketing Manager\r\nShelley              Higgins                   Accounting                     Accounting Manager\r\n\r\n7 rows selected.\r\n\r\nSQL&gt; \r\n\r\n\r\n\r\n<\/pre>\n<p>You can run the above INNER Join without INNER Join Clause as follows.<\/p>\n<pre>SQL&gt; select first_name,last_name,DEPARTMENT_NAME,JOB_TITLE from hr.employees e,hr.departments d,hr.jobs j where e.department_id=d.department_id and e.job_id=j.job_id and e.salary&gt;13000;\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_NAME                JOB_TITLE\r\n-------------------- ------------------------- ------------------------------ -----------------------------------\r\nNeena                Kochhar                   Executive                      Administration Vice President\r\nLex                  De Haan                   Executive                      Administration Vice President\r\nNancy                Greenberg                 Finance                        Finance Manager\r\nJohn                 Russell                   Sales                          Sales Manager\r\nKaren                Partners                  Sales                          Sales Manager\r\nMichael              Hartstein                 Marketing                      Marketing Manager\r\nShelley              Higgins                   Accounting                     Accounting Manager\r\n\r\n7 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"cdhZOg1ABh\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/\">Oracle SQL Tutorials For Beginners &#8211; Learn Oracle SQL from scratch with Oracle SQL Online Course<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle SQL Tutorials For Beginners &#8211; Learn Oracle SQL from scratch with Oracle SQL Online Course&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/embed\/#?secret=MuC5Y1IPNe#?secret=cdhZOg1ABh\" data-secret=\"cdhZOg1ABh\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain SQL Inner Join in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3019],"tags":[11976,11986,11991,11982,11981,11977,11987,11985,9037,11975,11990,11972,11989,11979,11974,11351,11304,11973,3001,11302,2673,11301,11983,3715,11978,11984,11980,11988,11992],"class_list":["post-16781","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-cross-join-oracle","tag-cross-join-sql","tag-full-outer-join-oracle","tag-inner-join-sql","tag-left-join-sql","tag-left-outer-join-in-oracle-with-multiple-conditions","tag-left-outer-join-sql","tag-natural-join-sql","tag-oracle-dba-tutorial","tag-oracle-inner-join-multiple-tables","tag-oracle-inner-join-vs-join","tag-oracle-join-multiple-tables","tag-oracle-join-syntax","tag-oracle-join-using","tag-oracle-left-outer-join-multiple-tables","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-join-3-tables","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-outer-join-sql","tag-pl-sql-tutorial","tag-right-outer-join-oracle","tag-sql-join-3-tables","tag-sql-join-and-join-types-in-oracle-sql","tag-sql-join-multiple-tables-with-conditions","tag-sql-join-where"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16781"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16781\/revisions"}],"predecessor-version":[{"id":16783,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16781\/revisions\/16783"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}