Oracle Error ORA-01764: new update value of join is not guaranteed to be unique

Oracle Error Message

ORA-01764: new update value of join is not guaranteed to be unique

Reason for the Error

A row of a join query table is being updated using a row of a table that is not guaranteed to have exactly one value for the row being updated.

Solution

Change the join specification.