Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex update query

Re: Complex update query

From: Alan <alan_at_erols.com>
Date: Fri, 17 Dec 2004 09:55:03 -0500
Message-ID: <32gaa5F3mnp25U1@individual.net>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US