Re: Updating a field from a different table

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 9 May 2002 15:10:11 -0500
Message-ID: <usn51krwm.fsf@grossprofit.com>

On 9 May 2002, todd.seidel_at_tfn.com wrote:

> I basically have two tables, I need to update one table with
> information from the other ....
>
> can someone help?

update

    (

     select   fld1   to_update,fld1   from_update
     from     t1,t2
     where t1.id = t2.id

    ) t3
set t3.to_update = t3.from_update

-- 
Galen Boyer

Received on Thu May 09 2002 - 15:10:11 CDT