Re: simple sql question

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 8 Jan 1999 01:13:06 GMT
Message-ID: <36995548.31956752@netnews.worldnet.att.net>

Probably something like:

update table_a a

	set f1 = (select b.f1
	from table_b b
	where a.f2 = b.f2
	and a.f1 <> b.f1);

I think the above should do what you are after.

Jonathan

On Thu, 07 Jan 1999 20:45:16 GMT, susana73_at_hotmail.com wrote:

>I am an ingres developer and new in oracle. I have the following simple
>Ingres SQL and am wondering how to change it to SQL in Oracle. Thanks!
>
>UPDATE table_a a
>FROM table_b b
>SET f1 = b.f1
>WHERE a.f2 = b.f2
>AND a.f1 != b.f1;
>
>Susan
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 07 1999 - 19:13:06 CST