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 -> Re: Simple update query from joined tables

Re: Simple update query from joined tables

From: Tim C <NOTCornwell_at_NOTcs.NOTcornell.NOTedu>
Date: Fri, 2 Aug 2002 13:27:22 -0400
Message-ID: <aiefdt$nfu$1@news01.cit.cornell.edu> 





Thanks Tom, I saw it.  Check my response.



What I have discovered since is that I'm very used to an extension that
Microsoft has to their implementation of the UPDATE statement:  the ability
to do just what I want.



In a nutshell:  You can use a select to join any tables you wish & then use
that result as a data source to do a keyed update any other table - as long
as the key is specified in the result you built.  Very handy.
Received on Fri Aug 02 2002 - 12:27:22 CDT












Original text of this message













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