Re: SQL Update

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/15
Message-ID: <961092371.12532.2.pluto.d4ee154e@news.demon.nl>#1/1

update (table_a,table_b) set table_a.data=table_b.data where table_a.kod=table_b.kod
I believe this is from Oracle 8.0 or 8i onwards.

Hth,

Sybrand Bakker, Oracle DBA

"Ulf Körnings" <ulf.kornings_at_mdh.se> wrote in message news:3948e631_at_news.mdh.se...
>
> Hi!
>
> I would like to do somthing like this in SQL:
>
> update table_a,table_b set table_a.data=table_b.data where
> table_a.kod=table_b.kod
>
> Is it possible?
>
> /Ulf
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT