1 Reply Latest reply: Feb 23, 2016 2:46 PM by Kaushik Solanki RSS

    Question about QlikView Association and SQL Join.

    Michael Wallman

      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.