{"id":16414,"date":"2020-07-18T06:19:32","date_gmt":"2020-07-18T06:19:32","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=16414"},"modified":"2020-07-18T06:19:34","modified_gmt":"2020-07-18T06:19:34","slug":"how-to-join-two-tables-using-left-join-in-sql","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-join-two-tables-using-left-join-in-sql\/","title":{"rendered":"How to join two tables using left join in  SQL."},"content":{"rendered":"\n<p><strong>Step:1<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"265\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table-1024x265.png\" alt=\"\" data-id=\"16415\" data-full-url=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table.png\" data-link=\"https:\/\/www.devopsschool.com\/blog\/?attachment_id=16415\" class=\"wp-image-16415\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table-1024x265.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table-300x78.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table-768x199.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/customers-table.png 1277w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><strong>Step:2<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"216\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/orders-table-1024x216.png\" alt=\"\" class=\"wp-image-16416\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/orders-table-1024x216.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/orders-table-300x63.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/orders-table-768x162.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/orders-table.png 1291w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step:3<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"681\" height=\"396\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/number-wise-graph-of-left-join-1.png\" alt=\"\" data-id=\"16419\" data-full-url=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/number-wise-graph-of-left-join-1.png\" data-link=\"https:\/\/www.devopsschool.com\/blog\/?attachment_id=16419\" class=\"wp-image-16419\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/number-wise-graph-of-left-join-1.png 681w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/number-wise-graph-of-left-join-1-300x174.png 300w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><strong>Step:4<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-3 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table-1024x231.png\" alt=\"\" data-id=\"16418\" data-full-url=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table.png\" data-link=\"https:\/\/www.devopsschool.com\/blog\/?attachment_id=16418\" class=\"wp-image-16418\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table-1024x231.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table-300x68.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table-768x173.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/07\/result-of-join-table.png 1488w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p><strong>Step:5<\/strong> Syntax of left join in SQL<\/p>\n\n\n\n<p>SELECT\u00a0<em>column_name(<strong>like that CustomerName and OrderID these are column name<\/strong> <span class=\"has-inline-color has-vivid-red-color\">step-4<\/span>)<\/em><br>FROM\u00a0<em>table1<\/em> (<strong>Cumstomers is table name<\/strong>)<br>LEFT\u00a0JOIN\u00a0<em>table2 (<strong>orders is table  name<\/strong>)<br><\/em>ON\u00a0<em>table1.column_name\u00a0<\/em>=<em>\u00a0table2.column_name<\/em>;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Step:1 Step:2 Step:3 Step:4 Step:5 Syntax of left join in SQL SELECT\u00a0column_name(like that CustomerName and OrderID these are column name step-4)FROM\u00a0table1 (Cumstomers is table name)LEFT\u00a0JOIN\u00a0table2 (orders is table name)ON\u00a0table1.column_name\u00a0=\u00a0table2.column_name;<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-16414","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=16414"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16414\/revisions"}],"predecessor-version":[{"id":16420,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/16414\/revisions\/16420"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=16414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=16414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=16414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}