Lastmitch I think above query will work on mysql Nagarjun you can use MERGE query to update table from another table in oracle merge destination_table d using source_table s on (d.key1=s.key1 and d.key2=s.key2) when matched then update set d.colx=s.coly
how to get values from other table to update table
Do you have this on your server? What version?
You didn't provide a table structure so I don't know what you have in your table.
Since you want to get a value from one table to another table. Kinda like a transfer.
You can try this example:
SET a.field_1 = b.field_1
FROM table_a a
INNER JOIN table_b b
ON a.id = b.id;