5 Replies Latest reply: Jul 1, 2013 9:15 AM by Robert Fishel RSS

    Populating an empty table with data from a temp table

    Robert Fishel

      Hello all.  I have created an empty table using the LOAD * INLINE statement.  Now I simply want to take data from a temp table created previously and store certain values in this new empty table.  Here is my code so far:

       

      tblTasks:
      LOAD * INLINE [
          Task_Number, available
      ];
      
      
      
      SELECT DISTINCT PSPLN
      RESIDENT tblPull
      ORDER BY PSPLN;
      

       

       

      How do you "select into" the empty table from the the resident table?  Thanks!!!