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

Re: Updating a field from a different table

From: Brian E Dick <bdick_at_cox.net>
Date: Thu, 09 May 2002 18:30:02 GMT
Message-ID: <KezC8.6546$1a4.478228@news2.east.cox.net>


A bit obtuse. Can you give some DDL?

"todd seidel" <todd.seidel_at_tfn.com> wrote in message news:a566f6f6.0205091022.65f1f477_at_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:30:02 CDT

Original text of this message

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