simple sql question

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 - 14:45:16 CST