You can't specify target table 'x' for update in FROM clause code example
Example: update you can't specify target table for update in from clause
UPDATE myTable
SET myTable.A =
(
SELECT B
FROM (SELECT * FROM myTable) AS something
INNER JOIN ...
)