今天在写以下SQL的UPDATE语句时,出现一个比较怪异的问题“You can't specify target table '****' for update in FROM clause”;
只需要在SELECT外面再嵌套一层即可解决,如下所示:
DELETE from rpt_chooser_individual_performance_total WHERE id not in (select id from
(select id from
rpt_chooser_individual_performance_total
group by site_id,product_no )a)