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 -> update with condition

update with condition

From: gil guerillot <gil.guerillot_at_ratp.fr>
Date: Tue, 28 Aug 2001 15:48:07 +0100
Message-ID: <3B8BAF27.76E99DF9@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:48:07 CDT












Original text of this message













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