使用UPDATE的目标表获取错误是不可更新的

I am running a simple MySQL query to update with sub-query . This is the query what i wrote I am running a simple MySQL query to update wit