This content has been marked as final. Show 5 replies
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';