0 Replies Latest reply: Jul 20, 2010 5:13 AM by EvgenyGin_J RSS

    How to do multiple joins in qlikview

    EvgenyGin_J

      select dj.id, dj.OpDate,dj.idPhysicalPerson, dr.idGoods,g.Name,dr.Amount
      from DocJournal as dj
      join drSales as dr on dr.idDoc = dj.id
      join refPhysicalPersons as pp on pp.id = dj.idPhysicalPerson
      join refGoods as g on g.id = dr.idGoods
      where dj.idPhysicalPerson in (123124,123125,123126)
      and dj.deleted= 0