Newbie question.

From: <john_whitfield_at_my-deja.com>
Date: Fri, 01 Sep 2000 17:41:53 GMT
Message-ID: <8oopot$2c7$1@nnrp1.deja.com>

I'm working in Oracle after years of programming in Sybase and I'm having difficulty with trying to render the following command in Oracle:

   UPDATE table1
   SET fieldname = t2.fieldname
   FROM table1 t1, table2 t2
   WHERE t1.keyfield = t2.keyfield

That's how I'd do it in Sybase anyway; the command is supposed to pick a field out of table2 based on a shared key and store it in a field in table1. Problem is, I can't find the equivalent in Oracle, there doesn't seem to be any kind of join in Oracle's syntax for the UPDATE statement. How do I perform a similar function in Oracle?

Any help would be appreciated.

AdvThanxance,
John Whitfield

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 01 2000 - 12:41:53 CDT