|Subject:||Complex update query|
|Posted by:||Mansoor Azam (mansoo…@shoa.net)|
|Date:||Fri, 17 Dec 2004|
I have a table T1 with columns ( C1,C2,C3).
I've written say a complex SELECT query that returns 3 fields say S1, S2, S3
of the same data type as that of C1, C2, C3.
What I want is to update the table T1's C3 value with S3 where C1 = S1 and
C2 = S2. how do I connect the UPDATE statement with the Select statement to
achieve the desired result.
UPDATE T1 Set C3 = S3
WHERE .......(select query goes here )