topic Re: Inner Join in QlikView https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337548#M124494 <HTML><HEAD></HEAD><BODY><P>You would have to use outer join if you want the full lists of both tables.</P></BODY></HTML> Fri, 03 Aug 2012 19:25:42 GMT Nicole-Smith 2012-08-03T19:25:42Z Inner Join https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337547#M124493 <HTML><HEAD></HEAD><BODY><P>Hello I am using Inner Join in my load script to load two excel files. I have two lists A and B.&nbsp; It pulls the attendee name that is featured in BOTH lists and puts it in a table. However it does not allow me to also have a table of the full list A and full list B. Is there a way to also get tables of the full lists by using inner join?</P></BODY></HTML> Fri, 03 Aug 2012 18:10:46 GMT https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337547#M124493 2012-08-03T18:10:46Z Re: Inner Join https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337548#M124494 <HTML><HEAD></HEAD><BODY><P>You would have to use outer join if you want the full lists of both tables.</P></BODY></HTML> Fri, 03 Aug 2012 19:25:42 GMT https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337548#M124494 Nicole-Smith 2012-08-03T19:25:42Z Re: Inner Join https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337549#M124495 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the answer to your previous post.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 06 Aug 2012 07:55:40 GMT https://community.qlik.com/t5/QlikView/Inner-Join/m-p/337549#M124495 Miguel_Angel_Baeyens 2012-08-06T07:55:40Z