{"id":6293,"date":"2019-03-12T17:19:48","date_gmt":"2019-03-12T22:19:48","guid":{"rendered":"https:\/\/itsoftware.com.co\/content\/?p=6293"},"modified":"2023-02-02T11:53:17","modified_gmt":"2023-02-02T16:53:17","slug":"usos-y-diferencias-entre-inner-left-y-right-join","status":"publish","type":"post","link":"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/","title":{"rendered":"Usos y diferencias entre Inner, Left y Right join"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contenidos<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Alternar tabla de contenidos\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0645ad;color:#0645ad\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0645ad;color:#0645ad\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Inner_Join\" >Relaci\u00f3n Inner Join<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Left_Join\" >Relaci\u00f3n Left Join<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Right_Join\" >Relaci\u00f3n Right Join<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Left_Outer_Join\" >Relaci\u00f3n Left Outer Join<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Right_Outer_Join\" >Relaci\u00f3n Right Outer Join<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/itsoftware.com.co\/content\/usos-y-diferencias-entre-inner-left-y-right-join\/#Relacion_Full_Outer_Join\" >Relaci\u00f3n Full Outer Join<\/a><\/li><\/ul><\/nav><\/div>\n\n<p class=\"wp-block-paragraph\">En el mundo de las bases de datos relacionales encontramos las palabras claves inner, left y right join, que se usan para encontrar relaciones entre dos tablas indexadas.  En este art\u00edculo vamos a ahondar sobre la utilidad y diferencias de cada una de ellas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para este fin vamos como a usar como ejemplo dos tablas indexadas entre s\u00ed, una llamada clientes y la otra ventas. Las dos tablas se relacionan entre s\u00ed por medio campos <em>clientes.id<\/em> (PK)  y <em>ventas.cliente_id<\/em> (FK).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/clientes.png\" alt=\"tabla clientes\" class=\"wp-image-9568\" width=\"439\" height=\"207\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/clientes.png 306w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/clientes-300x141.png 300w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><figcaption class=\"wp-element-caption\">Tabla Clientes &#8211; Diferencia inner, left. right join<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/ventas.png\" alt=\"tabla ventas\" class=\"wp-image-9569\" width=\"432\" height=\"212\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/ventas.png 342w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/ventas-300x147.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><figcaption class=\"wp-element-caption\"> <br>Tabla Ventas &#8211; Diferencia inner, left. right join <br><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Te invitamos a seguir leyendo las siguientes p\u00e1ginas donde mostraremos la diferencia entre las relaciones <strong>inner, left y right join<\/strong>:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Inner_Join\"><\/span>Relaci\u00f3n Inner Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con esta relaci\u00f3n se van a obtener los registros que son comunes a ambas tablas. En nuestro ejemplo, como la relaci\u00f3n es entre los campos <em>clientes.id<\/em> y <em>ventas.cliente_id<\/em>, el inner join va a obtener los registros donde ambos campos son iguales. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En el diagrama de Venn se muestra lo que se quiere obtener con esta relaci\u00f3n del ejemplo:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Inner-Join.png\" alt=\"Inner Join\" class=\"wp-image-6296\"\/><figcaption class=\"wp-element-caption\">Inner Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">En t\u00e9rminos de consulta SQL para MySQL tendr\u00edamos la siguiente sintaxis para el ejemplo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>inner join<\/strong>  ventas v on c.id=v.cliente_id<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Que en nuestro ejemplo da como resultado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Inner-Join-1.png\" alt=\"Resultado de Inner Join\" class=\"wp-image-9571\" width=\"749\" height=\"133\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Inner-Join-1.png 638w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Inner-Join-1-300x53.png 300w\" sizes=\"(max-width: 749px) 100vw, 749px\" \/><figcaption class=\"wp-element-caption\">Resultado de Inner Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Vemos entonces que aparecen con Inner Join los registros comunes a las dos tablas donde son iguales <em>clientes.id<\/em> y <em>ventas.cliente_id<\/em>, es decir donde est\u00e1n los c\u00f3digos 1 y 3.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Left_Join\"><\/span>Relaci\u00f3n Left Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con Left Join se obtiene adem\u00e1s de los registros comunes del  inner join, los registros que pertenecen a la tabla que se nombra a la izquierda de la consulta.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para nuestro ejemplo en el diagrama de Venn es as\u00ed:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Left-Join.png\" alt=\"Left Join\" class=\"wp-image-6298\"\/><figcaption class=\"wp-element-caption\">Left Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Que en consulta SQL para el ejemplo ser\u00eda as\u00ed:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>left join<\/strong>  ventas v on c.id=v.cliente_id<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Y da como resultado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"696\" height=\"156\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Left-Join.png\" alt=\"Resultado Left Join\" class=\"wp-image-9572\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Left-Join.png 696w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Left-Join-300x67.png 300w\" sizes=\"(max-width: 696px) 100vw, 696px\" \/><figcaption class=\"wp-element-caption\">Resultado Left Join<br><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Ahora con Left Join se obtienen los registros del inner join  (1 y 3), m\u00e1s los restantes registros de la tabla clientes (2 y 4).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Right_Join\"><\/span>Relaci\u00f3n Right Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con Right Join se obtiene adem\u00e1s de los registros comunes de inner, los que pertenecen a la tabla que se nombra a la derecha de la consulta.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Para el ejemplo en cuesti\u00f3n en el diagrama de Venn es as\u00ed:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Right-Join.png\" alt=\"\" class=\"wp-image-6300\"\/><figcaption class=\"wp-element-caption\">Right Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Y da como resulado en el ejemplo:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>left join<\/strong>  ventas v on c.id=v.cliente_id<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Right-Join.png\" alt=\"Resultado de Right Join\" class=\"wp-image-9573\" width=\"737\" height=\"152\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Right-Join.png 655w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-de-Right-Join-300x62.png 300w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><figcaption class=\"wp-element-caption\">Resultado de Right Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed vemos que adem\u00e1s de los registros del inner join (1,3), se obtuvieron los registros que faltaban de la tabla <em>ventas <\/em>(8).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Left_Outer_Join\"><\/span>Relaci\u00f3n Left Outer Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con Left Outer Join se obtienen los registros de la tabla de la izquierda que no son comunes a ambas tablas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Que en t\u00e9rminos del diagrama de Venn del ejemplo ser\u00eda as\u00ed:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Left-Outer-Join.png\" alt=\"Left Outer Join\" class=\"wp-image-6302\"\/><figcaption class=\"wp-element-caption\">Left Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Como estamos usando MySQL en el ejemplo, esta SQL ser\u00eda como \u00e9sta:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>left  join<\/strong>  ventas v on c.id=v.cliente_id where <strong>v.cliente_id is null<\/strong><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Y da como resultado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Left-Outer-Join.png\" alt=\"Resultado de Left Outer Join\" class=\"wp-image-9574\" width=\"825\" height=\"85\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Left-Outer-Join.png 682w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Left-Outer-Join-300x31.png 300w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><figcaption class=\"wp-element-caption\">Resultado de Left Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed vemos que s\u00f3lo salen los registros 2 y 4 de la tabla <em>clientes<\/em>, que no son comunes con la tabla <em>Ventas<\/em>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Right_Outer_Join\"><\/span>Relaci\u00f3n Right Outer Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con Right Outer Join se obtienen los registros de la tabla de la derecha que no son comunes a ambas tablas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Que en t\u00e9rminos del diagrama de Venn del ejemplo ser\u00eda:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Right-Outer-Join.png\" alt=\"\" class=\"wp-image-6303\"\/><figcaption class=\"wp-element-caption\">Right Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"> Como usamos MySQL en el ejemplo, la SQL ser\u00eda como \u00e9sta: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>right join<\/strong> ventas v on c.id=v.cliente_id where <strong>c.id  is null<\/strong><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Y da como resultado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Right-Outer-Join.png\" alt=\"Resultado de Right Outer Join\" class=\"wp-image-9575\" width=\"743\" height=\"57\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Right-Outer-Join.png 635w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Right-Outer-Join-300x23.png 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><figcaption class=\"wp-element-caption\">Resultado de Right Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed sale s\u00f3lo el registro con c\u00f3digo 8 de la tabla <em>ventas<\/em>, que es el valor no com\u00fan con la tabla <em>clientes<\/em>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relacion_Full_Outer_Join\"><\/span>Relaci\u00f3n Full Outer Join<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Con Full Outer Join se obtienen los registros de ambas tablas que no son comunes entre ellas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Que en el diagrama de Venn del ejemplo ser\u00eda:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/03\/Full-Outer-Join.png\" alt=\"\" class=\"wp-image-6304\"\/><figcaption class=\"wp-element-caption\">Full Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"> Como usamos MySQL en el ejemplo, esta SQL ser\u00eda como \u00e9sta: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">select * from clientes c <strong>left  join<\/strong>  ventas v on c.id=v.cliente_id where <strong>v.cliente_id is null<\/strong><br> <strong>union <\/strong><br>select * from clientes c <strong>right join<\/strong> ventas v on c.id=v.cliente_id where <strong>c.id  is null<\/strong><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Y da como resultado:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Full-Outer-Join.png\" alt=\"Resultado de Full Outer Join\" class=\"wp-image-9576\" width=\"770\" height=\"110\" srcset=\"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Full-Outer-Join.png 678w, https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2023\/02\/Resultado-Full-Outer-Join-300x43.png 300w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><figcaption class=\"wp-element-caption\">Resultado de Full Outer Join<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Aqu\u00ed no tenemos registros con valores comunes, s\u00f3lo aparecen registros donde<em> clientes.id <\/em>y <em>ventas.cliente_id<\/em> no son iguales en ambas tablas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Como conclusi\u00f3n, el uso adecuado de estas sentencias permite hacer consultas m\u00e1s efectiva en t\u00e9rminos de tiempo y de carga de procesamiento. Es tambi\u00e9n importante anotar que para que la consulta sea m\u00e1s eficiente, se deben indexar las tablas y generar los llaves primarias y for\u00e1neas de las tablas que se quieren relacionar. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Este art\u00edculo hace parte del sistema de divulgaci\u00f3n de conocimiento de <a href=\"http:\/\/itsoftware.com.co\">ITSoftware SAS<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Si te gust\u00f3, por favor no olvides compartirlo en las redes sociales. \ud83d\ude09<\/h4>\n","protected":false},"excerpt":{"rendered":"<p>En el mundo de las bases de datos relacionales encontramos las palabras claves inner, left y right join, que se usan para encontrar relaciones entre dos tablas indexadas. En este[&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":6699,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[97],"tags":[],"class_list":["post-6293","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/itsoftware.com.co\/content\/wp-content\/uploads\/2019\/04\/Left-Outer-Join.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/posts\/6293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/comments?post=6293"}],"version-history":[{"count":0,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/posts\/6293\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/media\/6699"}],"wp:attachment":[{"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/media?parent=6293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/categories?post=6293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itsoftware.com.co\/content\/wp-json\/wp\/v2\/tags?post=6293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}