Complex update query

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.

something like

UPDATE T1 Set C3 = S3
WHERE .......(select query goes here )

thx. Received on Fri Dec 17 2004 - 00:16:35 CST