Tags: alternatives, based, database, field, inner, mysql, oracle, relation, sql, table, tables, update, updating
How to update field from another table
I have two tables with inner join relation. What are the alternatives for updating a field from one of them based on a field of the other?(respecting thier primary keys).
Leave a comment...
- 2 Comments
update tab_a set col_a =(select col_b from tab_b where tab_a.col_key = tab_b.col_key)#1; Thu, 21 Feb 2008 23:05:00 GMT
- Dear Its called an equijoin and the reply is true and functional. I appreciate .....#2; Thu, 21 Feb 2008 23:06:00 GMT