dirkgomez.de

update 
  (select columnName, value
     from name, lookup
     where name.keyname = lookup.keyname
       and lookup.othercolumn = :other_value)
  set column_name = value;