[informix]Criar tabela temp

SELECT F.*
FROM T_ASSINANTESC A, T_FINTRAS_MAIS F
WHERE F.ftsubscribernr = A.cucustnr
AND F.ftaccnr = A.accountnr
INTO TEMP T_FINTRAS_MAIS2 with no log;