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






      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