topic Left Join 2 tables in QlikView https://community.qlik.com/t5/QlikView/Left-Join-2-tables/m-p/454111#M701431 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 2 xls files loading into qlikview with below sql condition. I need below sql condition to be converted into qlikview script.</P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">select a.* from TABLE a left join TABLE b on ( ( a.field1= b.feild2) or ( (a.Field3= b.Field4) or (a.Field3= b. Field5) ) )</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">Please help..</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">Thanks<BR /></SPAN></P></BODY></HTML> Fri, 28 Sep 2012 22:48:08 GMT Anonymous 2012-09-28T22:48:08Z Left Join 2 tables https://community.qlik.com/t5/QlikView/Left-Join-2-tables/m-p/454111#M701431 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have 2 xls files loading into qlikview with below sql condition. I need below sql condition to be converted into qlikview script.</P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">select a.* from TABLE a left join TABLE b on ( ( a.field1= b.feild2) or ( (a.Field3= b.Field4) or (a.Field3= b. Field5) ) )</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">Please help..</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: 13px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; background-color: #ffffff;">Thanks<BR /></SPAN></P></BODY></HTML> Fri, 28 Sep 2012 22:48:08 GMT https://community.qlik.com/t5/QlikView/Left-Join-2-tables/m-p/454111#M701431 Anonymous 2012-09-28T22:48:08Z