topic How to do multiple joins in qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-do-multiple-joins-in-qlikview/m-p/265924#M1204819 <HTML><HEAD></HEAD><BODY><P>select dj.id, dj.OpDate,dj.idPhysicalPerson, dr.idGoods,g.Name,dr.Amount<BR />from DocJournal as dj<BR />join drSales as dr on dr.idDoc = dj.id<BR />join refPhysicalPersons as pp on pp.id = dj.idPhysicalPerson<BR />join refGoods as g on g.id = dr.idGoods<BR />where dj.idPhysicalPerson in (123124,123125,123126)<BR />and dj.deleted= 0</P></BODY></HTML> Tue, 20 Jul 2010 09:13:53 GMT 2010-07-20T09:13:53Z How to do multiple joins in qlikview https://community.qlik.com/t5/QlikView/How-to-do-multiple-joins-in-qlikview/m-p/265924#M1204819 <HTML><HEAD></HEAD><BODY><P>select dj.id, dj.OpDate,dj.idPhysicalPerson, dr.idGoods,g.Name,dr.Amount<BR />from DocJournal as dj<BR />join drSales as dr on dr.idDoc = dj.id<BR />join refPhysicalPersons as pp on pp.id = dj.idPhysicalPerson<BR />join refGoods as g on g.id = dr.idGoods<BR />where dj.idPhysicalPerson in (123124,123125,123126)<BR />and dj.deleted= 0</P></BODY></HTML> Tue, 20 Jul 2010 09:13:53 GMT https://community.qlik.com/t5/QlikView/How-to-do-multiple-joins-in-qlikview/m-p/265924#M1204819 2010-07-20T09:13:53Z