topic Question about QlikView Association and SQL Join. in QlikView https://community.qlik.com/t5/QlikView/Question-about-QlikView-Association-and-SQL-Join/m-p/1094286#M639192 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am new to QlikView and was reading the reference manual where I came across the following (exact text):</P><P></P><P><STRONG>QlikView Association Compared to SQL Natural Outer Join</STRONG></P><P></P><P>A QlikView association resembles a SQL natural outer join. <SPAN style="color: #33cccc;">The QlikView association is however more general:</SPAN></P><P><SPAN style="color: #33cccc;">an outer join in SQL is usually a one way projection of one table on another. A QlikView association</SPAN></P><P><SPAN style="color: #33cccc;">always results in a full (bidirectional) natural outer join.</SPAN></P><P><SPAN style="color: #33cccc;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Can please anyone tell me what it means that SQL is usually a one way projection of one table on another? I don't understand this terminology.</SPAN></P></BODY></HTML> Tue, 23 Feb 2016 13:05:28 GMT mwallman 2016-02-23T13:05:28Z Question about QlikView Association and SQL Join. https://community.qlik.com/t5/QlikView/Question-about-QlikView-Association-and-SQL-Join/m-p/1094286#M639192 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am new to QlikView and was reading the reference manual where I came across the following (exact text):</P><P></P><P><STRONG>QlikView Association Compared to SQL Natural Outer Join</STRONG></P><P></P><P>A QlikView association resembles a SQL natural outer join. <SPAN style="color: #33cccc;">The QlikView association is however more general:</SPAN></P><P><SPAN style="color: #33cccc;">an outer join in SQL is usually a one way projection of one table on another. A QlikView association</SPAN></P><P><SPAN style="color: #33cccc;">always results in a full (bidirectional) natural outer join.</SPAN></P><P><SPAN style="color: #33cccc;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Can please anyone tell me what it means that SQL is usually a one way projection of one table on another? I don't understand this terminology.</SPAN></P></BODY></HTML> Tue, 23 Feb 2016 13:05:28 GMT https://community.qlik.com/t5/QlikView/Question-about-QlikView-Association-and-SQL-Join/m-p/1094286#M639192 mwallman 2016-02-23T13:05:28Z Re: Question about QlikView Association and SQL Join. https://community.qlik.com/t5/QlikView/Question-about-QlikView-Association-and-SQL-Join/m-p/1094287#M639194 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you know SQL it has right outer join or Left outer join, where you get full data from right table or left table depending on join,which means there is a one way of projection. Where as in QlikView you have full outer join which means you will get result from both the tables.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 Feb 2016 19:46:50 GMT https://community.qlik.com/t5/QlikView/Question-about-QlikView-Association-and-SQL-Join/m-p/1094287#M639194 kaushiknsolanki 2016-02-23T19:46:50Z