how to get values from other table to update table

 
0
 

how to get values from other table to update table

Featured Replies in this Discussion

  • 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
LastMitch
Deleted Member
 
0
 

@nagarajuapex

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:

UPDATE a
SET a.field_1 = b.field_1
FROM table_a a
INNER JOIN table_b b
ON a.id = b.id;
 
2
 

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

Comments
Nice Answer! I learn something from you!
LastMitch
Deleted Member
 
0
 

Lastmitch I think above query will work on mysql

I'm still trying to not confused myself with query in oracle or mysql.

The query you provided looks right!

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article