嵌套SQL查询在update语句中具有select子查询

I get an error near WHERE clause on executing this query. clause on executing t