Complex update query

Giganews Newsgroups
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.

something like

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

thx.

Replies