SQL Question: Update Syntax

Posted in 1998

Axel Sander — Mon, 14 Dec 1998 20:33:53 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, I'm fiddling around with the following SQL problem: I have 2 tables 'table1' and 'table2' each having the columns 'flag' and 'value'. How can I update table1.flag with the value of table2.flag where table1.value=table2.value The informix manual isn't very helpful on this problem. Axel