topic Outer joins while scripting in QlikView https://community.qlik.com/t5/QlikView/Outer-joins-while-scripting/m-p/288692#M107319 <HTML><HEAD></HEAD><BODY><P>Why not?</P><P>quote</P><H1><A name="kanchor763"></A><SPAN style="background-color: #b2b4bf; color: #000000;">Join</SPAN></H1><P>The <SPAN style="background-color: #b2b4bf;">join</SPAN> prefix <SPAN style="background-color: #b2b4bf;">joins</SPAN> the loaded table with an existing named table or the last previously created <A _jive_internal="true" href="https://community.qlik.com/Logical_table.htm">logical table</A>. The <SPAN style="background-color: #b2b4bf;">join</SPAN> is a <A _jive_internal="true" href="https://community.qlik.com/Natural_join.htm">natural <SPAN style="background-color: #b2b4bf; color: #000000;">join</SPAN></A> made over all the common <A _jive_internal="true" href="https://community.qlik.com/Field.htm">fields</A>. The <SPAN style="background-color: #b2b4bf;">join</SPAN> statement may be preceded by one of the prefixes <A _jive_internal="true" href="https://community.qlik.com/Inner.htm"><SPAN class="Bold">inner</SPAN></A>, <A _jive_internal="true" href="https://community.qlik.com/Outer.htm"><SPAN class="Bold">outer</SPAN></A>, <A _jive_internal="true" href="https://community.qlik.com/Left.htm"><SPAN class="Bold">left</SPAN></A> or <A _jive_internal="true" href="https://community.qlik.com/Right.htm"><SPAN class="Bold">right</SPAN></A>.</P><P>unqote</P><P></P><P>Peter</P></BODY></HTML> Wed, 15 Jun 2011 21:37:53 GMT prieper 2011-06-15T21:37:53Z Outer joins while scripting https://community.qlik.com/t5/QlikView/Outer-joins-while-scripting/m-p/288691#M107318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can some one&nbsp; help me if we can use outer joins and load data in QV? If so please let me know?</P></BODY></HTML> Wed, 15 Jun 2011 05:42:09 GMT https://community.qlik.com/t5/QlikView/Outer-joins-while-scripting/m-p/288691#M107318 kmswetha 2011-06-15T05:42:09Z Outer joins while scripting https://community.qlik.com/t5/QlikView/Outer-joins-while-scripting/m-p/288692#M107319 <HTML><HEAD></HEAD><BODY><P>Why not?</P><P>quote</P><H1><A name="kanchor763"></A><SPAN style="background-color: #b2b4bf; color: #000000;">Join</SPAN></H1><P>The <SPAN style="background-color: #b2b4bf;">join</SPAN> prefix <SPAN style="background-color: #b2b4bf;">joins</SPAN> the loaded table with an existing named table or the last previously created <A _jive_internal="true" href="https://community.qlik.com/Logical_table.htm">logical table</A>. The <SPAN style="background-color: #b2b4bf;">join</SPAN> is a <A _jive_internal="true" href="https://community.qlik.com/Natural_join.htm">natural <SPAN style="background-color: #b2b4bf; color: #000000;">join</SPAN></A> made over all the common <A _jive_internal="true" href="https://community.qlik.com/Field.htm">fields</A>. The <SPAN style="background-color: #b2b4bf;">join</SPAN> statement may be preceded by one of the prefixes <A _jive_internal="true" href="https://community.qlik.com/Inner.htm"><SPAN class="Bold">inner</SPAN></A>, <A _jive_internal="true" href="https://community.qlik.com/Outer.htm"><SPAN class="Bold">outer</SPAN></A>, <A _jive_internal="true" href="https://community.qlik.com/Left.htm"><SPAN class="Bold">left</SPAN></A> or <A _jive_internal="true" href="https://community.qlik.com/Right.htm"><SPAN class="Bold">right</SPAN></A>.</P><P>unqote</P><P></P><P>Peter</P></BODY></HTML> Wed, 15 Jun 2011 21:37:53 GMT https://community.qlik.com/t5/QlikView/Outer-joins-while-scripting/m-p/288692#M107319 prieper 2011-06-15T21:37:53Z