Left join with two key fields

[#1]

Hi,

Can anyone explain how Qlikview performs left join of two tables when they share two fieldnames in common?

Many thanks,

Murali

[vincent_ardiet · Accepted solution]

Hi,

It works like in SQL.

The two columns must have the same value to perform the join.

Regards,

Vincent

[#3]

Hi Vincent,

                  Will this work for all other types of join?

[vincent_ardiet]

Hi Kiran2in,

What do you mean ? Inner join, right outer join and full outer join ?

Here are some details:

- Using the key word JOIN in QV is the same as FULL OUTER JOIN in SQL ;

- LEFT JOIN in QV is the same as LEFT OUTER JOIN in SQL ;

- RIGHT JOIN in QV is the same as RIGHT OUTER JOIN in SQL ;

- INNER JOIN in QV is the same as INNER JOIN in SQL ;

So, the big difference is that, in QV, default joins are FULL OUTER JOIN, but, in SQL, default joins are INNER JOIN.

Then, in SQL you can specify on which columns you want to join either from the right table, either from the left table. But QV automaticaly joins columns with the same name and like in SQL, the combination of all values from those columns have to be the same in the left table and in the right table to perform the join (whatever type of join you choose).

Regards,

Vincent

[#5]

Hi Vincent,

Thanks for clarification.