Update with condition

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Tue, 28 Aug 2001 15:46:19 +0100
Message-ID: <3B8BAEBB.5E866007@ratp.fr>

I have 2 tables with 3 fields

F1
F2
F3

the common key is F1
i want to update T1.F1 with the value of T2.F1

but only when T1.F3 > T2.F3

how can i do simply (SQL) wihtout PL/SQL ?

thanks Received on Tue Aug 28 2001 - 09:46:19 CDT

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

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