LOAD using SELECT statement inside a WHERE clause

[Anonymous]

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.

[Gysbert_Wassenaar]

Perhaps like this:

Temp:

SELECT trade_id "temp_trade_id" FROM trade WHERE TRADE_YEAR < 2015 AND status=1);

concatenate(Trade)

LOAD

TRADE_ID,

...

...

...

...

RESIDENT Trade_temp

WHERE EXISTS (temp_trade_id, TRADE_ID);

Drop Table Temp;