sql update without pl/sql

[LKBrwn_DBA]

Try this:

update tbl1
set f1 = (select f2 from tbl2
where tbl1.f2 = tbl2.f3)
where f2 in (select f3 from tbl2
where... basically a bunch of f3s)
/