qlikview join vs sql joins

[#1]

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?

[its_anandrjs]

Hi,

Check some of this for better Joins explains how it works and what result you get after the joins.

Joins and Lookups

Some Qlikview Joins best documents

Different Join Functions in Qlikview

Regards

Anand