Oracle Error ORA-01776: cannot modify more than one base table through a join view

Oracle Error Message

ORA-01776: cannot modify more than one base table through a join view

Reason for the Error

Columns belonging to more than one underlying table were either inserted into or updated.

Solution

Phrase the statement as two or more separate statements.