12 Replies Latest reply: Mar 15, 2018 12:39 PM by Manish Kachhia RSS

    resident table

    Wanyun Yang

      Hi guys,

       

      In my data load editor, I want to write a SQL query based on another SQL query table, like:

       

      table1:

      SQL

      SELECT...

      FROM...

      WHERE...;

       

      table2:

      SQL

      SELECT...

      FROM Resident table1

      WHERE...;

       

      LOAD... Resident table2;

       

      What the grammar should be like?