topic inner joins using sql cursor in QlikView https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352627#M130851 <HTML><HEAD></HEAD><BODY><P>Dear&nbsp; all</P><P></P><P>I have following master in&nbsp; views sql </P><P></P><P><STRONG>PRODUCT MASTER&nbsp; VIEW</STRONG></P><P>----------------------------</P><P>product code </P><P>product name</P><P>category</P><P>brand</P><P>specialilty</P><P></P><P></P><P><STRONG>PRODUCT BATCH MASTER </STRONG></P><P>----------------------------------------</P><P>product code</P><P>mfg date</P><P>exp date</P><P>batch no</P><P></P><P>I want to join this two masters while loading data in qlikview in my script can any </P><P>one tell me the way how we can load and combine this masters while loading time only.</P><P></P><P>Thanks &amp; Regards</P><P></P><P>Vikas Mahajan </P></BODY></HTML> Mon, 16 Apr 2012 10:46:10 GMT vikasmahajan 2012-04-16T10:46:10Z inner joins using sql cursor https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352627#M130851 <HTML><HEAD></HEAD><BODY><P>Dear&nbsp; all</P><P></P><P>I have following master in&nbsp; views sql </P><P></P><P><STRONG>PRODUCT MASTER&nbsp; VIEW</STRONG></P><P>----------------------------</P><P>product code </P><P>product name</P><P>category</P><P>brand</P><P>specialilty</P><P></P><P></P><P><STRONG>PRODUCT BATCH MASTER </STRONG></P><P>----------------------------------------</P><P>product code</P><P>mfg date</P><P>exp date</P><P>batch no</P><P></P><P>I want to join this two masters while loading data in qlikview in my script can any </P><P>one tell me the way how we can load and combine this masters while loading time only.</P><P></P><P>Thanks &amp; Regards</P><P></P><P>Vikas Mahajan </P></BODY></HTML> Mon, 16 Apr 2012 10:46:10 GMT https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352627#M130851 vikasmahajan 2012-04-16T10:46:10Z inner joins using sql cursor https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352628#M130852 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can directly join the views and load the resultant table into qlikview.</P><P></P><P>TableName:</P><P>SQL SELECT</P><P>&nbsp;&nbsp;&nbsp;&nbsp; *</P><P>FROM View1 </P><P>INNER JOIN View2 </P><P>ON View1.Key = View2.Key;</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 16 Apr 2012 11:21:00 GMT https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352628#M130852 jagan 2012-04-16T11:21:00Z Re: inner joins using sql cursor https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352629#M130853 <HTML><HEAD></HEAD><BODY><P>Can give me syntax with data loading scripts</P><P></P><P>Thanks for help</P><P></P><P>Regards</P><P></P><P>Vikas</P></BODY></HTML> Mon, 16 Apr 2012 13:17:16 GMT https://community.qlik.com/t5/QlikView/inner-joins-using-sql-cursor/m-p/352629#M130853 vikasmahajan 2012-04-16T13:17:16Z