update affairs a set a.ISHASCHILD=1 where a.AFFAIRCODE in (SELECT DISTINCT(AF_PARENT) from affairs)
改成
update affairs a set a.ISHASCHILD=1 where a.AFFAIRCODE in (select AF_PARENT from (SELECT DISTINCT(AF_PARENT) from affairs) b)
需要中间再增加一次查询
update affairs a set a.ISHASCHILD=1 where a.AFFAIRCODE in (SELECT DISTINCT(AF_PARENT) from affairs)
改成
update affairs a set a.ISHASCHILD=1 where a.AFFAIRCODE in (select AF_PARENT from (SELECT DISTINCT(AF_PARENT) from affairs) b)
需要中间再增加一次查询