{"id":16785,"date":"2020-07-07T12:02:41","date_gmt":"2020-07-07T12:02:41","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16785"},"modified":"2020-07-07T12:02:41","modified_gmt":"2020-07-07T12:02:41","slug":"sql-left-outer-join-in-oracle-sql-oracle-sql-tutorials-21","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-left-outer-join-in-oracle-sql-oracle-sql-tutorials-21\/","title":{"rendered":"SQL Left Outer Join in Oracle SQL | Oracle SQL Tutorials -21"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain SQL Left Outer 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=\"bgCwngKRV9\"><p><a href=\"https:\/\/ittutorial.org\/sql-inner-join-in-oracle-sql-oracle-sql-tutorials-20\/\">SQL Inner Join in Oracle SQL | Oracle SQL Tutorials -20<\/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 Inner Join in Oracle SQL | Oracle SQL Tutorials -20&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/sql-inner-join-in-oracle-sql-oracle-sql-tutorials-20\/embed\/#?secret=BvTpqk1TIj#?secret=bgCwngKRV9\" data-secret=\"bgCwngKRV9\" 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 Left Outer Join<\/span><\/h4>\n<p>The Left Outer Join is used to list the records from the left table and the matched records from the right table.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Left (Outer) JOIN Syntax<\/span><\/h4>\n<p>Left Outer Join syntax is 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\">LEFT<\/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\"><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16786\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/left-outer-join-oracle-sql.jpg\" alt=\"\" width=\"264\" height=\"672\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/left-outer-join-oracle-sql.jpg 264w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/07\/left-outer-join-oracle-sql-118x300.jpg 118w\" sizes=\"auto, (max-width: 264px) 100vw, 264px\" \/><\/div>\n<div><\/div>\n<p>You can use left outer join as follows. Left outer join and left join clause run the same as follows.<\/p>\n<pre>SQL&gt; SELECT first_name,e.last_name, e.department_id, d.department_name\r\n  2     FROM   hr.employees e LEFT OUTER JOIN hr.departments d\r\n  3     ON   (e.department_id = d.department_id) where e.department_id&gt;80 ;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_ID DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------- ------------------------------\r\nNeena                Kochhar                              90 Executive\r\nLex                  De Haan                              90 Executive\r\nNancy                Greenberg                           100 Finance\r\nDaniel               Faviet                              100 Finance\r\nJohn                 Chen                                100 Finance\r\nIsmael               Sciarra                             100 Finance\r\nJose Manuel          Urman                               100 Finance\r\nLuis                 Popp                                100 Finance\r\nShelley              Higgins                             110 Accounting\r\nWilliam              Gietz                               110 Accounting\r\n\r\n10 rows selected.\r\n\r\nSQL&gt; \r\nSQL&gt; \r\nSQL&gt; SELECT first_name,e.last_name, e.department_id, d.department_name\r\n  2     FROM   hr.employees e LEFT JOIN hr.departments d\r\n  3     ON   (e.department_id = d.department_id) where e.department_id&gt;80 ;\r\n\r\nFIRST_NAME           LAST_NAME                 DEPARTMENT_ID DEPARTMENT_NAME\r\n-------------------- ------------------------- ------------- ------------------------------\r\nNeena                Kochhar                              90 Executive\r\nLex                  De Haan                              90 Executive\r\nNancy                Greenberg                           100 Finance\r\nDaniel               Faviet                              100 Finance\r\nJohn                 Chen                                100 Finance\r\nIsmael               Sciarra                             100 Finance\r\nJose Manuel          Urman                               100 Finance\r\nLuis                 Popp                                100 Finance\r\nShelley              Higgins                             110 Accounting\r\nWilliam              Gietz                               110 Accounting\r\n\r\n10 rows selected.\r\n\r\nSQL&gt;<\/pre>\n<p>fe<\/p>\n<p>&nbsp;<\/p>\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=\"1uflkNIDZc\"><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=7h0dnkn0z9#?secret=1uflkNIDZc\" data-secret=\"1uflkNIDZc\" 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 Left Outer 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,11982,11981,11977,11987,11985,9037,11994,11975,11972,11979,11996,11993,11974,11995,11351,11304,11973,3001,11302,2673,11301,11983,3715,11978,11984,11980,11988],"class_list":["post-16785","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-cross-join-oracle","tag-cross-join-sql","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-full-outer-join","tag-oracle-inner-join-multiple-tables","tag-oracle-join-multiple-tables","tag-oracle-join-using","tag-oracle-left-join-subquery","tag-oracle-left-join-vs-left-outer-join","tag-oracle-left-outer-join-multiple-tables","tag-oracle-left-outer-join-with-null-condition","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"],"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\/16785","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=16785"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16785\/revisions"}],"predecessor-version":[{"id":16788,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16785\/revisions\/16788"}],"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=16785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}