-118 THE OBJECT TABLE OR VIEW OF THE DELETE OR UPDATE STATEMENT IS ALSO IDENTIFIED IN A FROM CLAUSE

Explanation
 The table or view specified as the object of a
DELETE or UPDATE statement also appears in the FROM clause of a subselect
within the statement.
The table or view that is the object of
a UPDATE or DELETE cannot also be used to supply the values to be
inserted or to qualify the rows to be updated or deleted.

System action
 The statement cannot be processed. No
data was updated or deleted.

Programmer response
 Create a temporary copy of the object table
or view, and perform the subselect on that copy.

SQLSTATE
 42902