1,105,295 Community Members

how to get values from other table to update table

Member Avatar
nagarajuapex
Newbie Poster
2 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

how to get values from other table to update table

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;
Member Avatar
urtrivedi
Posting Virtuoso
1,897 posts since Dec 2008
Reputation Points: 249 [?]
Q&As Helped to Solve: 408 [?]
Skill Endorsements: 27 [?]
 
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

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 three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article