JOIN

[adiarnon]

HI,

if im writing only join (not inner/outer/left/right).

how its act?

tnx,

adi

[senpradip007]

It behaves like Natural Join.

[ashfaq_haseeb]

Hi,

go through the below post.

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ

[giakoum]

Outer

The explicit Join prefix can be preceded by the prefix outer in order to specify an outer join. In an outer join all combinations between the two tables are generated. The resulting table will thus contain combinations of field values from the raw data tables where the linking field values are represented in one or both tables. The outer keyword is optional.

[adiarnon]

what do you mean by natural join?

[#6 · Accepted solution]

Writin only 'join' means full outer join. As the default join in qlikview is full outer join