In an INSERT or UPDATE statement issued on a join view table, the column values that functionally depend on the referencing columns of the referencing table conflict with the existing column values.
This conflict may be solved by changing either the column values specified in the INSERT or UPDATE statement or the existing values.