Joined Row Update

Posted in 2006

Jose da Fonseca — Wed, 5 Jul 2006 19:30:12 +0200 — source: Usenet: comp.databases.informix

Can anyone tell me if it is possible to do a joined row update (available in XPS) on ids 10 ?? syntax on XPS Update table1 set table1.col1 = table2.col3 from table1, table2 where table1.col1 = table2.col1; Thank you in advance José

↪ replying to Jose da Fonseca

Art S. Kagel — Wed, 05 Jul 2006 13:47:07 -0400 — source: Usenet: comp.databases.informix

Jose da Fonseca wrote: > Can anyone tell me if it is possible to do a joined row update (available in XPS) on ids 10 ?? > > syntax on XPS > > Update table1 > set table1.col1 = table2.col3 > from table1, table2 > where table1.col1 = table2.col1; Not supported in IDS. You have to use sub-queries. There have been at least two other questions on this in the last month. Peruse the archive. Art S. Kagel > Thank you in advance > José >

Glossary

IDS (Informix Dynamic Server)