join

[master_student]

Hello Guys,

A join in qlikview is equivalent to outer join or inner join?

Thanks

[mayankraoka]

By default it is outer join.Creating all possible combinations of values from thetwo tables.

Prefer to always explicitly state which sort of join you want, even for an outer join. The code is more clear that way.

Regards,

Mayank

[Anonymous]

Hi,

I think....

Outer join is equivalent to join...

because..join is not going to filter the data it just append the both tables fields into single table,if there is any common fields join will merge that filed data and other fields just append into first table.

and

where as in inner join it is going to filter the data based on link filed ,if suppose there no link filed it will treated as a  normal join.

and

where as in outer join is not going to filter the data it just append the both the tables as like normal join.