Help with the Update command

mparak · Post by **mparak** » 22.07.2006, 16:42

Dear Friends

I am trying to update a value in one table with a value form a different table.

The update command seems to be the logical way. Can somebody help me with the SQL command that would update a single field from one table to another.

Update Table1, Table2
set table1.EndValue=Table2.somefield
where table1.indexfield=table2.indexfield.

I am working with Interbase, in this project, but the answer will help me in my work with MysqL as well..

Regards

MParak
Durban South Africa.

mparak · Post by **mparak** » 22.07.2006, 21:54

I have been able to do a multi table update, in MySQL, but the syntax is clearly different for Firebird.
Therein lies the problem.

zippo · Post by **zippo** » 23.07.2006, 08:33

Yes, MySQL has some differences in syntax and in some cases whole SQL statemens.