Help with the Update command
Posted: 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.
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.