Hi,
Does anyone know if its safe to use the update + from syntax on version 14.10?
There is no documentation and no mention in "what news", however the syntax below works!
create temp table tp1 ( cod int , nome char(10)) with no log ;
create temp table tp2 ( cod int , nome char(10)) with no log ;
insert into tp1 select tabid, tabname from systables ;
insert into tp2 select tabid, '' from systables ;
select * from tp2 where cod = 100
update tp1
set nome = tp2.nome
from tp2
where tp2.cod = tp1.cod
and tp2.cod = 100
------------------------------
Cesar Martins
------------------------------
#Informix