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 -> Updating a field from a different table

Updating a field from a different table

From: todd seidel <todd.seidel_at_tfn.com>
Date: 9 May 2002 11:22:25 -0700
Message-ID: <a566f6f6.0205091022.65f1f477@posting.google.com> 





Hello, 



I'm trying to get an update to run and I've researched a couple
solutions but I don't think they will work for this case...I think
this should be relatively easy though.




This is what I'd like to do 



update FC_MOD set FC_MOD.parent_key= FC.tfn
where 


concat(F.ticker,'.CF')=M.ticker




I basically have two tables, I need to update one table with
information from the other ....



can someone help?



todd
Received on Thu May 09 2002 - 13:22:25 CDT












Original text of this message













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