2 Replies Latest reply: Mar 29, 2017 9:26 AM by Krishnapriya Arumugam RSS

    Joining Tables from multiple DB's

    Seth Rosenbauer

      Can you join tables from multiple DB's and inner join.

       

      For example, I know that you can do the following:

       

      //connection 1

      final:

      Load *

      ;

      Sql select table 1

      from db1

       

       

      //connection 1

      inner join(final)

      Load *

      ;

      Sql select table 2

      from db2

       

      However, in doing this you must first load the entire table 1 and table 2 into Qlikview. The tables i'm dealing with are very large(47 million rows) and I would like to do the inner join immediately without pulling in the entire table. Is this possible?