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

From: Timothy Ranma <diablo_at_ksts.seed.net.tw>
Date: Thu, 15 Mar 2001 09:08:01 +0800
Message-ID: <r150bt4r26p8jvm0ektbkg899np0f33pc3@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 - 19:08:01 CST