Re: replacing values in a table from another table

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 13 Mar 2004 08:02:47 -0800
Message-ID: <1079193741.221983@yasure>

Michel Cadot wrote:

> "Rocky" <me_at_privacy.net> a écrit dans le message de news:c2v0kf$a7b$1_at_reader13.wxs.nl...
>

>>Hi,
>>I'm new to oracle and probably this is quite simple for most of you. I have
>>2 tables with following structure:

>
> Something like:
> update table1
> set value=(select table2.value where table2.pr=table1.pr and table2.au=table1.au)
> where exists (select 1 from table2 where table2.pr=table1.pr and table2.au=table1.au);
>
> Regards
> Michel Cadot

Warning to regulars ... it is once again time when those of us that teach are giving out end-of-quarter finals. Please provide hints ... and not solutions ... Thanks.

Spring Quarter begins at the beginning of April so expect a new crop of academic questions then too.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Mar 13 2004 - 10:02:47 CST