sql报错： Every derived table must have its own alias
用的是mysql数据库
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 ( 11 (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' ) ) 12 < 13 (SELECT statusSum from (select COUNT(path_status) as statusSum FROM tb_cr_circulate_gtsc where order_id='Ph800601211123155507' and is_current_point='1') ) 14 )
报错提示：每一个派生出来的表都必须有一个自己的别名
解决方式：在新产生表的地方加上别名
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' ) as a) 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') as a ) 5 )
