5 Replies Latest reply: Jun 4, 2014 8:24 PM by Vishnu Sreekumar RSS

    Require help with Join syntax for resident tables

    Vishnu Sreekumar

      Hi,

       

      I am facing a problem with joining two resident tables in qlikview.

       

      Table A has fields

      SlNO

      START_DATE

      STOP_DATE

       

      Table B has fields

      SINO

      ADMIT_DATE

       

       

      I want to join the bigger table A to smaller table B such that, B would be joined to A on

      SINO

      and only when B.ADMIT date between A.START_DATE and A.STOP_DATE

       

      Kindly guide me.

       

      Regards,

      Vishnu S