4 Replies Latest reply: Jun 26, 2013 4:48 AM by Raja Kaliyamoorthy RSS

    Qlikview : Conditional join QVD

      Hi,

      Please give me some input on these :

       

      I have a table 1 (fields : start_time) and table 2 (fields : start_time, end_time)

      i wanted to join them like this :

       

      SQL statement :

      select *

      from table1 a

      join table2 b

      on a.start_time<= b.start_time AND b.start_time <= a.end_time

       

       

      qlikview statement :

      ?

       

      Thanks,