Need help.
My employer asked me to update multiple records in a table using data from another table. I am experienced with SQL but I am relatively new to Informix.. I am not a programmer though.

It seems that the common (access, MS SQL Server) syntax joining the two tables is not understandable with Informix.

what I am used to:

update table1
set table1.field2=table2.field2
from table1 inner join table2 on table1.field1=table2.field1

Informix Dynamic Server 9.4 on SuSE SLES 8

Thanx.

update table1
set table1.field2 = (select table2.field2 from table2 where table1.field1=table2.field1)
where table1.field1 in (select table2.field1 from table2)

Everything worked, thanx for your help.
Cheers!!!

Everything worked fine, thanx for your help.
Cheers!!!