Re: SQL Question: Update Syntax

Posted in 1998

M00n321 — 22 Dec 1998 10:09:28 GMT — source: Informix-list mailing list archive (1991-1998)

>How can I update table1.flag with the value of table2.flag >where table1.value=table2.value > UPDATE table1 SET flag = ( SELECT flag FROM table2 WHERE table2.value = table1.value) WHERE 1 = 1; #all records You will want to make sure that both table1 and table2 are indexed on value unless these tables are very small (row count).