Home » SQL & PL/SQL » SQL & PL/SQL » update query
update query [message #260872] Tue, 21 August 2007 03:03 Go to next message
dr46014
Messages: 48
Registered: February 2007
Member

i have 2 tables tab1 and tab2.tab1 is having 2 columns C1,C2 and tab2 is having 3 columns C1,C2,C3.
C1 is the key column.i want to update C2 of table2 with matching values from C2 of table 1.
tab1 is having 100 rows and tab2 is having 200 rows.all the rows in tab1 is in tab2.So it would be a kind of outer join(left).
please suggest me a update query
Re: update query [message #260880 is a reply to message #260872] Tue, 21 August 2007 03:11 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Until you learn some netiquette and start replying to the people who have supplied you with answers for your past posts, I will not answer you, and I hope that no-one else will until you learn some courtesy.
Re: update query [message #260882 is a reply to message #260872] Tue, 21 August 2007 03:14 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I concur.

Regards
Michel
Previous Topic: Dynamic SQL and the ORA-01489: result of string concatenation is too long
Next Topic: what tools can write select statement better?
Goto Forum:
  


Current Time: Sat Dec 03 01:18:26 CST 2016

Total time taken to generate the page: 0.08039 seconds