10 Replies Latest reply: Dec 19, 2014 11:42 AM by Anand Chouhan RSS

    qlikview join vs sql joins

      Hello,

       

      I have a question!

       

      I have in qlikview a tempbase which is first joined on my big table - what is join similar to in SQL - is it a inner join?

       

       

      example:

       

      Table1:

      Row

      Row2

      Row3

      Row4

      Row4+Row3 as Row_34

       

      from xxxx

       

      table_tmp:

      load

      Row

      Row2

      Row_34

       

      resident table1;

       

      join(table1)

      load

      Row_34

      max(row) as RowMax

       

      resident table_tmp

       

       

       

      So what does the join means? is it a left or inner join?