Home » Other » Training & Certification » Hoy to update a column of table A with data from column of table B?
Hoy to update a column of table A with data from column of table B? [message #259352] Wed, 15 August 2007 03:22 Go to next message
atgl
Messages: 25
Registered: March 2006
Junior Member
Hi,

I want to update column A of table 1 with data from column B of table 2 where connection of both table is via primary key of both table 1 & 2.

Sample Table 1
Columm C1    Column A
1           Jack
2           Mary


Sample Table 2
Columm C2    Column B
1           Jack J. Mole
2           Mary Kit


At the end of the day, my table 1 should look like below:-
Column C1    Column A
1            Jack J. Mole
2            Mary Kit


Table 2 is just a temp table. And I am using Oracle 8i.
Re: Hoy to update a column of table A with data from column of table B? [message #259357 is a reply to message #259352] Wed, 15 August 2007 03:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just use a join.
Tell us what you already try and where you are stuck.

Regards
Michel
Previous Topic: Packages
Next Topic: What is "pragma autonomous transaction"? (renamed by LF)
Goto Forum:
  


Current Time: Fri Mar 29 00:24:19 CDT 2024