3 Replies Latest reply: Jun 26, 2015 7:44 AM by Onno van Knotsenburg RSS

    Simple Join in QlikView

      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