Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UPDATE using multiple tables

Re: UPDATE using multiple tables

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 22 Apr 2005 18:11:01 -0400
Message-ID: <3ctb3rF6nfrtaU1@individual.net> 





 > update tableA

 >   set date_reported = (select audit_date from tableB

 >                         where tableB.skey_ref = tableA.skey)

where exists(select 1 from tableB

                where tableB.skey_ref = tableA.skey)






Cheers


Serge



PS: Also look at MERGE

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab


Received on Fri Apr 22 2005 - 17:11:01 CDT












Original text of this message













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