5 Replies Latest reply: May 18, 2012 3:14 AM by Jason Michaelides RSS

    Query

      I would like to know how can I achieve this SQL query in Qlikview?


      SELECT *
      FROM tab1 a, tab2 b
      where a.AY=b.A_Y
      and a.Sem=b.SEM
      and a.CC=b.C_CDE& "-" &U_C
      and b.ROLE='XXX'
      and a.FID <> b.O_PNO;