Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update multiple rows of a table by the values in another table

Status
Not open for further replies.

rkvelagapudi

Programmer
Aug 6, 2001
1
FR
I need to update multiple multiple rows of a table by picking values from another table.

Example:

Table1: Cert_number Date_1 Date_2 Date_3
values: C1 x y z

Table2: Cert_number Sequence Date
C1 1 x
C1 2 y
C1 3 z
I need to update date field of table2 by reading from table1

I have achieved this by writing three update statements. But this affects performance. Is there a way where I can do it with single update statement.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top