Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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