topic Re: JOIN in QlikView https://community.qlik.com/t5/QlikView/JOIN/m-p/627419#M1091325 <HTML><HEAD></HEAD><BODY><P>Writin only 'join' means full outer join. As the default join in qlikview is full outer join</P></BODY></HTML> Mon, 26 May 2014 06:41:33 GMT 2014-05-26T06:41:33Z JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627414#M1091320 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>if im writing only<STRONG> join</STRONG> (<STRONG>not</STRONG> inner/outer/left/right).</P><P></P><P>how its act?</P><P></P><P>tnx,</P><P>adi</P></BODY></HTML> Mon, 26 May 2014 06:32:21 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627414#M1091320 adiarnon 2014-05-26T06:32:21Z Re: JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627415#M1091321 <HTML><HEAD></HEAD><BODY><P>It behaves like Natural Join.</P></BODY></HTML> Mon, 26 May 2014 06:37:02 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627415#M1091321 senpradip007 2014-05-26T06:37:02Z Re: JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627416#M1091322 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>go through the below post.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6562">http://community.qlik.com/docs/DOC-6562</A></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 26 May 2014 06:37:21 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627416#M1091322 ashfaq_haseeb 2014-05-26T06:37:21Z Re: JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627417#M1091323 <HTML><HEAD></HEAD><BODY><H1><A name="kanchor916"></A>Outer</H1><P>The explicit <A class="MCXref_0"><EM>Join</EM></A> prefix can be preceded by the prefix <SPAN class="Bold">outer</SPAN> in order to specify an outer join. In an outer join all combinations between the two tables are generated. The resulting table will thus contain combinations of field values from the raw data tables where the linking field values are represented in one or both tables. <STRONG>The <SPAN class="Bold">outer</SPAN> keyword is optional. </STRONG></P></BODY></HTML> Mon, 26 May 2014 06:37:24 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627417#M1091323 giakoum 2014-05-26T06:37:24Z Re: JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627418#M1091324 <HTML><HEAD></HEAD><BODY><P><BR />what do you mean by natural join?</P></BODY></HTML> Mon, 26 May 2014 06:40:47 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627418#M1091324 adiarnon 2014-05-26T06:40:47Z Re: JOIN https://community.qlik.com/t5/QlikView/JOIN/m-p/627419#M1091325 <HTML><HEAD></HEAD><BODY><P>Writin only 'join' means full outer join. As the default join in qlikview is full outer join</P></BODY></HTML> Mon, 26 May 2014 06:41:33 GMT https://community.qlik.com/t5/QlikView/JOIN/m-p/627419#M1091325 2014-05-26T06:41:33Z