Simple Join in QlikView

[#1]

Hi,

I am trying to import data from 2 tables with a simple SQL join such as:

SQL SELECT top 100* FROM TABLE_1 a

inner JOIN

TABLE_2 b on a.column_name=b.column_name;

But I am getting an error saying OLEDB read failed. Please guide on how I should correct it to get the query ready to load the data into QV

Kindly help.

Thanks

[Gysbert_Wassenaar]

The sql statement is send directly to the database. If you get an error then either the database can't process the sql statement or there's another problem with the OLEDB driver and/or the database. Try the same sql statement in another database tool.

And make sure there's a space between 100 and the *. 100* is not a valid number.

[oknotsen]

Alternatively, load the data into QlikView and do the join there.

[oknotsen]

If your question is answered, please flag the right answer and close the topic.

If not, please make clear how we can help you more.