var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update field from other table
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:
from table1 inner join table2 on table1.field1=table2.field1
Informix Dynamic Server 9.4 on SuSE SLES 8
Originally Posted by Themis
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.
Everything worked fine, thanx for your help.