The target table '%1!s!' of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when ...

The target table '%1!s!' of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found reference constraint '%2!s!'.