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

    LOAD using SELECT statement inside a WHERE clause

    Welliton Paiva

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










      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.