5 Replies Latest reply: May 26, 2017 4:14 AM by Jonathan Dienst RSS

    Left join 3 Tables

    Alexandr Bekher

      Hello,

       

      Try to load part of table into QlikSense, but there is no examples about join in SQL queries.

      I try to use standart sql syntax, but engine return error. What is wrong?

       

      SQL SELECT "Sales_Date",

          "Doc_Type",

          "Doc_ID",

          "REP_id",

          "SKU_ART"

      FROM Sales.dbo.Sales as t1 left join Sales.dbo.SKU t2 on t1.SKU_ART = t2.SKU_Art

      left join Sales.dbo.REP t3 on t1.REP_id=t3.REP_id

      where t3.REP_Department like 'abc' OR t2.P_Format like '123';