{"id":270,"date":"2014-07-09T04:02:53","date_gmt":"2014-07-09T12:02:53","guid":{"rendered":"http:\/\/www.tech.dimprash.com\/?p=270"},"modified":"2019-05-15T17:41:54","modified_gmt":"2019-05-16T01:41:54","slug":"joins","status":"publish","type":"post","link":"http:\/\/www.tech.dimprash.com\/?p=270","title":{"rendered":"Joins"},"content":{"rendered":"<p>INNER JOIN: Returns all rows when there is at least one match in BOTH tables<br \/>\nLEFT JOIN: Return all rows from the left table, and the matched rows from the right table<br \/>\n(Tip: Read it as : All rows from Left + The Join)<br \/>\nRIGHT JOIN: Return all rows from the right table, and the matched rows from the left table<\/p>\n<p>CROSS JOIN: It gives us combinations of each row of first table with all records in second table<br \/>\nFULL JOIN:\u00a0 a <b>full outer join<\/b> combines the effect of applying both left and right outer joins. Where rows in the FULL OUTER JOINed tables do not match, the result set will have NULL values for every column of the table that lacks a matching row. For those rows that do match, a single row will be produced in the result set (containing columns populated from both tables).<\/p>\n<p>https:\/\/www.guru99.com\/joins.html<\/p>\n<p><a href=\"http:\/\/www.tech.dimprash.com\/wp-content\/uploads\/2014\/07\/main-qimg-97d3fc1ae3aee94265bc505df65106f5-c.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1021 size-full\" src=\"http:\/\/www.tech.dimprash.com\/wp-content\/uploads\/2014\/07\/main-qimg-97d3fc1ae3aee94265bc505df65106f5-c.jpg\" alt=\"\" width=\"602\" height=\"546\" srcset=\"http:\/\/www.tech.dimprash.com\/wp-content\/uploads\/2014\/07\/main-qimg-97d3fc1ae3aee94265bc505df65106f5-c.jpg 602w, http:\/\/www.tech.dimprash.com\/wp-content\/uploads\/2014\/07\/main-qimg-97d3fc1ae3aee94265bc505df65106f5-c-300x272.jpg 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>INNER JOIN: Returns all rows when there is at least one match in BOTH tables LEFT JOIN: Return all rows from the left table, and the matched rows from the right table (Tip: Read it as : All rows from Left + The Join) RIGHT JOIN: Return all rows from the right table, and the &hellip; <a href=\"http:\/\/www.tech.dimprash.com\/?p=270\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Joins<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-270","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/posts\/270","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=270"}],"version-history":[{"count":6,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions"}],"predecessor-version":[{"id":1022,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=\/wp\/v2\/posts\/270\/revisions\/1022"}],"wp:attachment":[{"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=270"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.tech.dimprash.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}