{"id":6349,"date":"2019-08-02T13:01:42","date_gmt":"2019-08-02T16:01:42","guid":{"rendered":"https:\/\/kb.elipse.com.br\/?p=6349"},"modified":"2019-08-12T10:14:42","modified_gmt":"2019-08-12T13:14:42","slug":"retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/","title":{"rendered":"Retornando os valores de m\u00faltiplas tabelas do Elipse E3 com a cl\u00e1usula INNER JOIN."},"content":{"rendered":"<h2>Combinando os valores de v\u00e1rias tabelas do Elipse E3 com INNER JOIN<\/h2>\n<p style=\"text-align: justify;\">Uma das possibilidades dos bancos de dados do Elipse E3 \u00e9 combinar os valores de duas ou mais tabelas em um \u00fanico resultado. Para combinar estes valores, antes de tudo \u00e9 preciso utilizar a cl\u00e1usula INNER JOIN do SQL. Com esta cl\u00e1usula, os registros das tabelas associadas s\u00e3o posteriormente agregados em uma \u00fanica consulta. A figura abaixo ilustra como os dados em comum entre as duas tabelas ser\u00e3o apresentados com a utiliza\u00e7\u00e3o desta cl\u00e1usula, a saber:<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/1.png\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-6351\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/1.png\" alt=\"\" width=\"250\" height=\"177\" \/><\/a><\/p>\n<h6 style=\"text-align: center;\">Figura 1. Funcionamento da cl\u00e1usula INNER JOIN<\/h6>\n<h3 style=\"text-align: justify;\">Sintaxe INNER JOIN<\/h3>\n<p>Para adicionar a cl\u00e1usula INNER JOIN, utilize a sintaxe abaixo na edi\u00e7\u00e3o direta do SQL:<\/p>\n<p><em>SELECT\u00a0column_name(s)<\/em><\/p>\n<pre><\/pre>\n<p><em>FROM\u00a0table1<\/em><\/p>\n<pre><\/pre>\n<p><em>INNER\u00a0JOIN\u00a0table2 ON\u00a0table1.column_name\u00a0=\u00a0table2.column_name; <\/em><\/p>\n<h3><\/h3>\n<h3 style=\"text-align: justify;\">Exemplo:<\/h3>\n<p style=\"text-align: justify;\">Para este exemplo, foram utilizadas duas tabelas, <strong>Tab_Cor<\/strong> e a <strong>Tab_Valor<\/strong>; uma vez combinadas, atrav\u00e9s do campo <strong>Nome<\/strong>, estas tabelas retornam\u00a0 as colunas Data(E3TimeStamp), Cor, Valor, Quantidade e ID na mesma consulta.<\/p>\n<p style=\"text-align: justify;\">Logo ap\u00f3s, foi habilitada a edi\u00e7\u00e3o direta do SQL, na aba <strong>SQL<\/strong> da consulta, e inserido o seguinte c\u00f3digo:<\/p>\n<p><em>SELECT Tab_Valor.E3TimeStamp AS Data,Tab_Cor.Nome,Tab_Cor.Cor,Tab_Valor.Valor,Tab_Valor.Quantidade,Tab_Cor.ID FROM Tab_Valor INNER JOIN Tab_Cor ON Tab_Cor.Nome = Tab_Valor.Nome ORDER BY Tab_Valor.E3TimeStamp ASC <\/em><\/p>\n<p>Ent\u00e3o, o resultado obtido com a agrega\u00e7\u00e3o dos valores das duas tabelas \u00e9 o que est\u00e1 apresentado na figura abaixo:<\/p>\n<p><em><a href=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/2.png\"><img loading=\"lazy\" class=\"size-full wp-image-6352 aligncenter\" src=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/2.png\" alt=\"\" width=\"624\" height=\"83\" \/><\/a><\/em><\/p>\n<h6 style=\"text-align: center;\">Figura 2. Resultado da consulta<\/h6>\n<p>Posteriormente a esse exemplo, apresentamos uma aplica\u00e7\u00e3o demo desenvolvida com Elipse E3 v4.8.352.<\/p>\n<h3>Anexos:<\/h3>\n<p><a href=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/INNER_JOIN.zip\">INNER_JOIN.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Combinando os valores de v\u00e1rias tabelas do Elipse E3 com INNER JOIN Uma das possibilidades dos bancos de dados do Elipse E3 \u00e9 combinar os valores de duas ou mais&hellip;<\/p>\n","protected":false},"author":24,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[583,578],"tags":[861,862],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3<\/title>\n<meta name=\"description\" content=\"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3\" \/>\n<meta property=\"og:description\" content=\"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-02T16:01:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-12T13:14:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/1.png\" \/>\n<meta name=\"author\" content=\"Lucas Angelo dos Santos\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lucas Angelo dos Santos\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\"},\"author\":{\"name\":\"Lucas Angelo dos Santos\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/8274d4e8758d0bba9797ed62ca568851\"},\"headline\":\"Retornando os valores de m\u00faltiplas tabelas do Elipse E3 com a cl\u00e1usula INNER JOIN.\",\"datePublished\":\"2019-08-02T16:01:42+00:00\",\"dateModified\":\"2019-08-12T13:14:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\"},\"wordCount\":539,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"keywords\":[\"INNER JOIN\",\"SQL\"],\"articleSection\":[\"DataBases\",\"Elipse E3\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\",\"name\":\"Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-08-02T16:01:42+00:00\",\"dateModified\":\"2019-08-12T13:14:42+00:00\",\"description\":\"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Retornando os valores de m\u00faltiplas tabelas do Elipse E3 com a cl\u00e1usula INNER JOIN.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/8274d4e8758d0bba9797ed62ca568851\",\"name\":\"Lucas Angelo dos Santos\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/89d677b6c8a8d6a100499aaec8fb46f6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/89d677b6c8a8d6a100499aaec8fb46f6?s=96&d=mm&r=g\",\"caption\":\"Lucas Angelo dos Santos\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/santos\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3","description":"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/","og_locale":"en_US","og_type":"article","og_title":"Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3","og_description":"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.","og_url":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-08-02T16:01:42+00:00","article_modified_time":"2019-08-12T13:14:42+00:00","og_image":[{"url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/delio\/6349\/1.png"}],"author":"Lucas Angelo dos Santos","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lucas Angelo dos Santos","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/"},"author":{"name":"Lucas Angelo dos Santos","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/8274d4e8758d0bba9797ed62ca568851"},"headline":"Retornando os valores de m\u00faltiplas tabelas do Elipse E3 com a cl\u00e1usula INNER JOIN.","datePublished":"2019-08-02T16:01:42+00:00","dateModified":"2019-08-12T13:14:42+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/"},"wordCount":539,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"keywords":["INNER JOIN","SQL"],"articleSection":["DataBases","Elipse E3"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/","url":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/","name":"Cl\u00e1usula INNER JOIN para retornar m\u00faltiplas tabelas do E3","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-08-02T16:01:42+00:00","dateModified":"2019-08-12T13:14:42+00:00","description":"Este artigo mostra como retornar valores de duas ou mais tabelas do Elipse E3 em uma \u00fanica consulta com a cl\u00e1usula INNER JOIN do SQL.","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/retornando-os-valores-de-multiplas-tabelas-do-elipse-e3-com-a-clausula-inner-join-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Retornando os valores de m\u00faltiplas tabelas do Elipse E3 com a cl\u00e1usula INNER JOIN."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/8274d4e8758d0bba9797ed62ca568851","name":"Lucas Angelo dos Santos","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/89d677b6c8a8d6a100499aaec8fb46f6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/89d677b6c8a8d6a100499aaec8fb46f6?s=96&d=mm&r=g","caption":"Lucas Angelo dos Santos"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/santos\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/6349"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=6349"}],"version-history":[{"count":11,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/6349\/revisions"}],"predecessor-version":[{"id":8231,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/6349\/revisions\/8231"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=6349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=6349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=6349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}