topic left join in QlikView https://community.qlik.com/t5/QlikView/left-join/m-p/684273#M1064865 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>There is three tables -A with 25 records,B with 15 records and C with 30 records. And you are doing Left Join Between A and B&nbsp; , right join between B and C . What would be the end result?</P></BODY></HTML> Wed, 24 Sep 2014 15:55:18 GMT 2014-09-24T15:55:18Z left join https://community.qlik.com/t5/QlikView/left-join/m-p/684273#M1064865 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>There is three tables -A with 25 records,B with 15 records and C with 30 records. And you are doing Left Join Between A and B&nbsp; , right join between B and C . What would be the end result?</P></BODY></HTML> Wed, 24 Sep 2014 15:55:18 GMT https://community.qlik.com/t5/QlikView/left-join/m-p/684273#M1064865 2014-09-24T15:55:18Z Re: left join https://community.qlik.com/t5/QlikView/left-join/m-p/684274#M1064867 <HTML><HEAD></HEAD><BODY><P>First you are doing Right Join B - C.... There are 30 records..... drop table C..</P><P>Now A - B left join... Drop table B... 25 records...</P></BODY></HTML> Wed, 24 Sep 2014 15:59:59 GMT https://community.qlik.com/t5/QlikView/left-join/m-p/684274#M1064867 MK_QSL 2014-09-24T15:59:59Z Re: left join https://community.qlik.com/t5/QlikView/left-join/m-p/684275#M1064868 <HTML><HEAD></HEAD><BODY><P>You will have 30 rows.</P><P>Have a look at below post</P><P><A href="https://community.qlik.com/docs/DOC-6562">QlikView Joins</A></P><P></P><P></P><P></P><P>regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 24 Sep 2014 16:37:28 GMT https://community.qlik.com/t5/QlikView/left-join/m-p/684275#M1064868 ashfaq_haseeb 2014-09-24T16:37:28Z Re: left join https://community.qlik.com/t5/QlikView/left-join/m-p/684276#M1064869 <HTML><HEAD></HEAD><BODY><P>I think it depends on the values of the fields used for the joins.</P><P>Are they all distinct? </P></BODY></HTML> Wed, 24 Sep 2014 20:04:28 GMT https://community.qlik.com/t5/QlikView/left-join/m-p/684276#M1064869 maxgro 2014-09-24T20:04:28Z