Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mwallman
Contributor

Question about QlikView Association and SQL Join.

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.

1 Reply

Re: Question about QlikView Association and SQL Join.

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

Community Browser