Comparison of  Oracle and Qlikview Joins.................

    Comparison of  Oracle and Qlikview Joins.................

     

    1). "UNION"  is resembled by "OUTER JOIN"

     

     

    2). "UNION ALL" is resembled by "CONCATENATE"

     

    3). Condition >

         where T1.field1=T2.field2

                                              is "INNER JOIN" in Qlikview

     

    4). Condition >

         where T1.field1=T2.field2(+)

                                              is "LEFT JOIN" in Qlikview

     

     

    5). Condition >

         where T1.field1(+)=T2.field2

                                              is "RIGHTJOIN" in Qlikview

     

     

     

    Regards

    Nitin