how to get values from other table to update table
nagarajuapex
0
Newbie Poster
Recommended Answers
Jump to PostLastmitch 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
All 3 Replies
LastMitch
urtrivedi
276
Nearly a Posting Virtuoso
LastMitch
commented:
Nice Answer! I learn something from you!
+0
LastMitch
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.