update FAILED_CUSTOMER SET kind=3 where id in
(
select fc.id
from CUSTOMER c ,CUSTOMER_INFO ci , FAILED_CUSTOMER fc
where c.id=ci.customer_id and ci.id=fc.customer_info_id and fc.info_id='ff80808122ec835e0122ec885d880007'
)为啥错误提示”you can't specify target table "FAILED_CUSTOMER" for update in FROM CLAUSE“?()圈起来的select语句是可以查出对应id的
(
select fc.id
from CUSTOMER c ,CUSTOMER_INFO ci , FAILED_CUSTOMER fc
where c.id=ci.customer_id and ci.id=fc.customer_info_id and fc.info_id='ff80808122ec835e0122ec885d880007'
)为啥错误提示”you can't specify target table "FAILED_CUSTOMER" for update in FROM CLAUSE“?()圈起来的select语句是可以查出对应id的
你更改下条件,不要把要update的表写在in里面