Help - where is FROM clause in update?

How do you include a join operation when using SQL to perform an update? I am using Oracle 6.0 with embedded SQL. I have some values from my embedded program and I want to populate a table with these values AND I also need some values from other tables.

the SQL syntax seems to say that you can "set column = value" or "set column = (query)" I need to do both. If I have 5 values that I am updating from another table, do I have to "set column = (query)" 5 times, once from each value?

I am use to using Ingres 6.4 which DOES have a 'from' clause which makes this very easy. Does Oracle 7 have it? Is there an ANSI standard?

-- 

Dan Jackson            AT&T Somerset NJ, USA
danj_at_cbnewsg.att.com   (908)-805-1461