Zeoslib Portal

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.

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

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