2 Replies Latest reply: Jul 12, 2010 9:51 AM by Dinesh Thoniparambil RSS

    Outer Join

      Table A & B are joined by column ID. I let Qlickview do the join based on the column name (no explicit JOIN statement in script). There are some nulls in column ID in table B. When I display in straight table all columns from table B, the rows having nulls in column ID are not displayed. I thought that Qlickview default behaviour is full outer join. How can one explain above? What do I have to do to display rows with NULL's in column ID?

       

      Thanks,

      Dinesh.