5 Replies Latest reply: May 27, 2011 11:04 AM by Joakim Wasseng RSS

    Need help with converting SQL JOIN to QlikView LEFT JOIN

    Joakim Wasseng

      I'm looking for help with converting this SQL-syntax to QlikView? I'm not sure how to create a JOIN-statement for table oru --> oh---> salj

       

      SELECT

      oru.artnr 

      ,salj.koststallekod    

       

      FROM oru

       

      JOIN oh ON

      oru.foretagkod = oh.foretagkod

      AND oru.ordernr = oh.ordernr

       

      JOIN salj ON

      oh.foretagkod = salj.foretagkod

      AND UPPER(oh.saljare) = UPPER(salj.saljare)

       

      WHERE oru.ordlevdat >= '20110101'

       

      Thanks //Joakim