3 Replies Latest reply: Sep 19, 2012 8:04 AM by kritichitranshi RSS

    How to join two tables as per below where clause

      Hi,

       

      I am a newbie in qlikview and quite unaware of qlikview scripting...

       

      please help me in joining these two tables as per the below sql statement.

       

      select ORGANIZATION_CODE, GROSS_WRITTEN_PREMIUM, DISCOUNT, OTHER_CHARGES, GST, COMMISSION1, COMMISSION2, NET_WRITTEN_PREMIUM, TRANSACTION_NUMBER

       

      from DIM_ORGANIZATION, FT_PREMIUM_TRANSACTION

       

      where DIM_ORGANIZATION.ORGANIZATION_KEY = FT_PREMIUM_TRANSACTION.COMPANY_PARTY_KEY

       

      Please help me its little urgent..

       

      Many Thanks

      Kriti