Question about QlikView Association and SQL Join.

[mwallman]

Hello all,

I am new to QlikView and was reading the reference manual where I came across the following (exact text):

QlikView Association Compared to SQL Natural Outer Join

A QlikView association resembles a SQL natural outer join. The QlikView association is however more general:

an outer join in SQL is usually a one way projection of one table on another. A QlikView association

always results in a full (bidirectional) natural outer join.

Can please anyone tell me what it means that SQL is usually a one way projection of one table on another? I don't understand this terminology.

[kaushiknsolanki]

Hi,

If you know SQL it has right outer join or Left outer join, where you get full data from right table or left table depending on join,which means there is a one way of projection. Where as in QlikView you have full outer join which means you will get result from both the tables.

Regards,

Kaushik Solanki