SQL: Invalid SET expression in UPDATE, "table name" is not a target table (Error 2149)

The UPDATE statement in the SELECT - SQL Command contains an invalid table reference in the SET expression.