Re: Complex update query

"Mansoor Azam" <mansoorb_at_shoa.net> wrote in message news:32fbsoF3m1r5iU1_at_individual.net...
> 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.
>
>
>

Look up correlated subqueries. Received on Fri Dec 17 2004 - 08:55:03 CST