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

    Left join 3 Tables

    Alexandr Bekher



      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",





      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';