10 Replies Latest reply: Feb 22, 2018 3:46 PM by Wanyun Yang RSS

    SQL query doesn't work when loading data from ODBC into Qlik Sense

    Wanyun Yang

      Hi guys,

       

      I'm loading data from ODBC into Qlik Sense. My question is:

       

      I have Table1 with columns A,B, Table2 with columns A,D. I want to left join Table2 on Table1 by column A, and show column  B and D.

       

      The SQL query is like:

      SELECT T1.B, T2.D

      FROM Table1 T1 LEFT JOIN Table2 T2

      ON T1.A=T2.A

       

      But this query doesn't work in Qlik Sense data load editor. How can I fix it?

       

      Thanks in advance!