topic Re: join in Brasil https://community.qlik.com/t5/Brasil/join/m-p/824207#M26466 <HTML><HEAD></HEAD><BODY><P>oracle?</P><P>this works in my oracle db</P><P></P><P>select </P><P>A.EMPNO as AEMPNO, </P><P>B.ENAME, B.EMPNO</P><P>FROM TEST.EMP A, TEST.EMP2 B</P><P><STRONG>where A.EMPNO = B.EMPNO</STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /></P><P>;</P></BODY></HTML> Tue, 03 Mar 2015 20:09:42 GMT maxgro 2015-03-03T20:09:42Z join https://community.qlik.com/t5/Brasil/join/m-p/824206#M26465 <HTML><HEAD></HEAD><BODY><P>Coloquei essa condição no meu select dentro da extração</P><P>e quando eu dou load nela dá erro</P><P></P><P>AND&nbsp;&nbsp; A.CD_AUTORIZACAO_SENHA&nbsp; =&nbsp; Z.CD_AUTORIZACAO_SENHA(+)</P><P></P><P>Algúem sabe dizer se essa condição com ( + ) também funciona na extração</P><P>porque no PlSQL ele funciona</P></BODY></HTML> Tue, 03 Mar 2015 20:00:04 GMT https://community.qlik.com/t5/Brasil/join/m-p/824206#M26465 2015-03-03T20:00:04Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824207#M26466 <HTML><HEAD></HEAD><BODY><P>oracle?</P><P>this works in my oracle db</P><P></P><P>select </P><P>A.EMPNO as AEMPNO, </P><P>B.ENAME, B.EMPNO</P><P>FROM TEST.EMP A, TEST.EMP2 B</P><P><STRONG>where A.EMPNO = B.EMPNO</STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /></P><P>;</P></BODY></HTML> Tue, 03 Mar 2015 20:09:42 GMT https://community.qlik.com/t5/Brasil/join/m-p/824207#M26466 maxgro 2015-03-03T20:09:42Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824208#M26467 <HTML><HEAD></HEAD><BODY><P>com () não funcionar&nbsp; você deixa somente + ou escreve Join (escreve o join e melhor)</P></BODY></HTML> Wed, 04 Mar 2015 11:13:50 GMT https://community.qlik.com/t5/Brasil/join/m-p/824208#M26467 srchagas 2015-03-04T11:13:50Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824209#M26468 <HTML><HEAD></HEAD><BODY><P>Isso pode ser configuração que esteja faltando no driver odbc ou oledb</P></BODY></HTML> Thu, 05 Mar 2015 13:27:58 GMT https://community.qlik.com/t5/Brasil/join/m-p/824209#M26468 nicolett_yuri 2015-03-05T13:27:58Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824210#M26469 <HTML><HEAD></HEAD><BODY><P>Boa tarde Valber</P><P></P><P>Qual é o comando SQL que você está executando?</P></BODY></HTML> Fri, 06 Mar 2015 18:31:16 GMT https://community.qlik.com/t5/Brasil/join/m-p/824210#M26469 Marcio_Campestrini 2015-03-06T18:31:16Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824211#M26470 <HTML><HEAD></HEAD><BODY><P>sim Marcio, eu coloquei o join e deu certo, como foi sugerido acima pelo o Thiago</P></BODY></HTML> Fri, 06 Mar 2015 18:53:58 GMT https://community.qlik.com/t5/Brasil/join/m-p/824211#M26470 2015-03-06T18:53:58Z Re: join https://community.qlik.com/t5/Brasil/join/m-p/824212#M26471 <HTML><HEAD></HEAD><BODY><P>Deu certo com o join! Obrigado</P></BODY></HTML> Fri, 06 Mar 2015 18:54:19 GMT https://community.qlik.com/t5/Brasil/join/m-p/824212#M26471 2015-03-06T18:54:19Z