Re: update with condition

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Aug 2001 15:50:57 +0200
Message-ID: <ton8f6sj15c211@news.demon.nl>

"gil guerillot" <gil.guerillot_at_ratp.fr> wrote in 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
>
>
>

Please post your homework somewhere else, definitely not 2 times within 2 minutes and buy a book on SQL.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 08:50:57 CDT