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

From: Timothy Ranma <diablo_at_ksts.seed.net.tw>
Date: Thu, 15 Mar 2001 12:33:01 +0800
Message-ID: <m4h0btcnnehl4akar3ssk9vjgb1smufred@4ax.com>

On Wed, 14 Mar 2001 21:20:14 -0500, "Sand" <chuichi_chan_at_MEOW.hotmail.com> wrote:

>Have you tried this?
>
>UPDATE TABLEA
>SET TABLEA.B = (SELECT B FROM TABLEB WHERE PK = TABLEA.PK)
but if select B more than one rows ?
TableB have more than one PK (like ...Pk,Pk1,PK2) or want to use cursor ?
in this case ? (sounds bad)

thx for your answer
>> 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 ?

---

The eyes are blind.One must look with the heart Tim Ranma Received on Wed Mar 14 2001 - 22:33:01 CST