标题: You can't specify target table 'c_fqc_group_mapping_t' for update in FROM clause [打印本页] 作者: zhgc 时间: 2021-6-16 13:54 标题: You can't specify target table 'c_fqc_group_mapping_t' for update in FROM clause You can't specify target table 'c_fqc_group_mapping_t' for update in FROM clause
delete from sfc.c_fqc_group_mapping_t
where ( model_name,almtype,group_name,idd) not in (
select model_name,almtype,group_name,min(idd) from sfc.c_fqc_group_mapping_t
group by model_name,almtype,group_name)
改为
delete from sfc.c_fqc_group_mapping_t
where ( model_name,almtype,group_name,idd) not in
(select * from
(
select model_name,almtype,group_name,min(idd) from sfc.c_fqc_group_mapping_t
group by model_name,almtype,group_name
) aa
)
