Page 1 of 1

Help with the Update command

Posted: 22.07.2006, 16:42
by mparak
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.

Posted: 22.07.2006, 21:54
by mparak
I have been able to do a multi table update, in MySQL, but the syntax is clearly different for Firebird.
Therein lies the problem.

Posted: 23.07.2006, 08:33
by zippo
Yes, MySQL has some differences in syntax and in some cases whole SQL statemens.