Home -> Usenet -> comp.databases.oracle -> SQL update??

SQL update??

From: Mahesh Bommareddy <mahesh_at_cis.ksu.edu>
Date: 25 Mar 92 21:41:28 GMT
Message-ID: <mahesh.701560013_at_depot.cis.ksu.edu> 






Could someone please help this novice with this problem



I have got two tables T1(field1,field2,field3) and T2(field1,field2,field3)
. Both the tables have the same structure.



I have to update field2 in T1 with the value of field2 in T2 where the field1
value should be the same for both the tuples.(field1 is the unique key for both
T1 and T2).



Thanks a lot,


mahesh
Received on Wed Mar 25 1992 - 22:41:28 CET












Original text of this message