Re: Update statement syntax -- Please Help!!

Posted in 1999

Eugene Nechayev — Fri, 01 Oct 1999 18:28:46 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7t2rd4$8ie$1@nnrp1.deja.com>, pbandaru@my-deja.com wrote: > Hello All, > > Need a quick help with the update syntax. I am trying to update a > column in one table with the values from another table. I am trying the > general SQL syntax that I know. But it does not work. > > Can some body please help in this. > > THe syntax I am using is > > UPDATE table1, table2 > set table1.col1=table2.col2 > where table1.col3=table2.col3 > UPDATE table1 SET table1.col1=(SELECT table2.col2 FROM table2 WHERE table1.col3=table2.col3) Regards, Eugene Nechayev Sent via Deja.com http://www.deja.com/ Before you buy.