Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Updating a field from a different table
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