子查询连表更新

UPDATE yt_city
SET re_ff_status = 1
WHERE
id IN (
SELECT
*
FROM
(
SELECT
c.id
FROM
yt_city c
INNER JOIN yt_ff f ON c.City = f.city
) tt
)