ORA-01764: new update value of join is not guaranteed to be unique
What triggered 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.What should we do to fix it:
Change the join specification.