topic Inner Join in QlikView https://community.qlik.com/t5/QlikView/Inner-Join/m-p/219753#M72738 <HTML><HEAD></HEAD><BODY><P>We have 2 tables namely <B>INVOICE</B>(with fields invoice no, contract no, invoice weight(kg)) and <B>CONTRACT</B>(with fields contract no , contract weight(kg)). How we can perform an inner join to merge the two tables? Plz send the codes for the above.</P></BODY></HTML> Fri, 10 Dec 2010 06:37:05 GMT 2010-12-10T06:37:05Z Inner Join https://community.qlik.com/t5/QlikView/Inner-Join/m-p/219753#M72738 <HTML><HEAD></HEAD><BODY><P>We have 2 tables namely <B>INVOICE</B>(with fields invoice no, contract no, invoice weight(kg)) and <B>CONTRACT</B>(with fields contract no , contract weight(kg)). How we can perform an inner join to merge the two tables? Plz send the codes for the above.</P></BODY></HTML> Fri, 10 Dec 2010 06:37:05 GMT https://community.qlik.com/t5/QlikView/Inner-Join/m-p/219753#M72738 2010-12-10T06:37:05Z Inner Join https://community.qlik.com/t5/QlikView/Inner-Join/m-p/219754#M72739 <HTML><HEAD></HEAD><BODY><P>user the inner join command.</P><P>LOAD</P><P>....</P><P>from tableA</P><P>INNER JOIN</P><P>LOAD</P><P>...</P><P>from tableB</P><P></P><P>The inner join will be based on the common field name. In this case, the Contract No.</P></BODY></HTML> Fri, 10 Dec 2010 06:48:01 GMT https://community.qlik.com/t5/QlikView/Inner-Join/m-p/219754#M72739 2010-12-10T06:48:01Z