SQL语句改错，[Err] 1093 - You can't specify target table 'parcel' for update in FROM clause

SQL语句的纠错，[Err]1093-可以 # 039；t指定目标表 # 039；包裹 # 039；FROM clauseSQL语句中for update的错误更正，[Err]1093-您可以 # 039；t指定目标表 # 039；包裹 # 039；for update in FROM子句简介:更新宗地集parcel _ status = 1 where parcel _ parcel num in(select parcel _ parcel num FROM parcel