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

[wanyunyang]

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!

[wanyunyang]

Thanks!