在Oracle Update语句中使用子查询而不是表名

I need write an update statement that used multiple tables to determine which rows to update, since in Oracle, multiple tables aren't allowed. The following query will return a "ORA-00971: Missing SET keyword" errorI need write an update statement that used mult