3 Replies Latest reply: Mar 8, 2017 10:57 PM by vimarsh saxena RSS

    Is it possible to load table from database connection based on the values from resident table

    vimarsh saxena

      I have 'Table1' as below

      Table1:

      LOAD ID, Name;

      LIB CONNECT TO <My Database Connection>;

      SELECT ID, NAME FROM <MyTable1>;

       

      I want to load another table from my database connection like below:

       

      Table2:

      LIB CONNECT TO <My Database Connection>;

      SELECT ID, NAME, ADDRESS, PHONE FROM <MyTable2>

      WHERE ID=(All ID values in resident Table1);


      Is there a way to achieve this?