Re: CAN I USE LIKE "UPDATE TABLEA SET ... FROM TABLEB WHERE ........

From: Sand <chuichi_chan_at_MEOW.hotmail.com>
Date: Wed, 14 Mar 2001 21:20:14 -0500
Message-ID: <2WVr6.33$Wd4.356@read1>

Have you tried this?

UPDATE TABLEA
SET TABLEA.B = (SELECT B FROM TABLEB WHERE PK = TABLEA.PK) "Timothy Ranma" <diablo_at_ksts.seed.net.tw> wrote in message news:r150bt4r26p8jvm0ektbkg899np0f33pc3_at_4ax.com...
> dear man
> I can use sql
> like
>
> update TABLEA
> set TABLEA.B=TABLEB.B
> from TABLEB
> where TABLEA.PK=TABLEB.PK
>
> in MS SQL 7.0
>
> but how to do in oracle ?
> use sub sql ?
>
> Thanks for your answer.
> ------------------------------------------------------------------------
> The eyes are blind.One must look with the heart Tim Ranma
Received on Wed Mar 14 2001 - 20:20:14 CST