sql报错：You can't specify target table 'tb_cr_circulate_gtsc' for update in FROM clause
用的是mysql数据库
sql语句如下
1 UPDATE tb_cr_circulate_gtsc 2 set path_status='A06' 3 where 4 order_id='Ph800601211123155507' 5 and 6 receive_role='21075116-001' 7 and 8 receive_role_name='024722cd-b197-462f-bdc2-f0423d88e580&Z&11caea25-4996-4682-aa3c-ea698e5140cc&21075116-001&四川省川东农药化工有限公司' 9 and 10 ((select COUNT(path_status) FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and path_status='A04' and is_current_point='1' )
< (select COUNT(path_status) FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and is_current_point='1') )
根据网上所查：不能在同一个sql语句中，先select同一个表的某些值，然后再update这个表。
解决方式：通过一个中间表多select一次
1 ( 2 (SELECT statusSum from (select COUNT(path_status) as statusSum FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and path_status='A04' and is_current_point='1' ) ) 3 < 4 (SELECT statusSum from (select COUNT(path_status) as statusSum FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and is_current_point='1') ) 5 )
