rkvelagapudi
Programmer
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
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