Re: update with condition

From: CF <new_at_flajolet.com>
Date: Tue, 28 Aug 2001 16:57:53 +0200
Message-ID: <9mgd79$sba$1@reader1.fr.uu.net>

declare
cursor cur_update is
select t2.f1,t2.f2
from t1,t2
where t1.f1 = t2.f1
and t1.f3 > t2.f3;

begin
for rec in cur_update loop
update t1 set f2 = rec.f2
where f1 = rec.f1;
end loop;
end;
commit;

Regards CF.

"gil guerillot" <gil.guerillot_at_ratp.fr> a écrit dans le message news: 3B8BAF27.76E99DF9_at_ratp.fr...
> I have 2 tables with 3 fields
>
> T1
>
> F1
> F2
> F3
>
>
> T2
>
> F1
> F2
> F3
>
> the common key is F1
> i want to update T1.F2 with the value of T2.F2
>
> but only when T1.F3 > T2.F3
>
> how can i do simply (SQL) wihtout PL/SQL ?
>
> thanks
>
>
>
Received on Tue Aug 28 2001 - 09:57:53 CDT