1 Reply Latest reply: May 29, 2015 11:50 AM by Gysbert Wassenaar RSS

    LOAD using SELECT statement inside a WHERE clause

      When I execute this piece of code, the "Garbage after statement" error shows.

       

       

      concatenate(Trade)

      LOAD

      TRADE_ID,

      ...

      ...

      ...

      ...

      RESIDENT Trade_temp

      WHERE TRADE_ID IN (SELECT trade_id FROM trade WHERE TRADE_YEAR < 2015 AND status=1);

       

      I need to use the SELECT statement because I don't have all the information in the Trade.