you can't specify target 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 ...
)