In this blog post, let’s learn about the error message “360 Cannot modify table or view used in subquery.” in Hydra and the description of the error.
Error Message
360 Cannot modify table or view used in subquery.
Error Details
The UPDATE, INSERT, or DELETE statement uses data taken from the same table in a subquery. This action is not allowed because of the danger of getting into an endless loop. Select the input data into a temporary table first, and then refer to the temporary table in the UPDATE or INSERT statement.