update select

• 代码

代码

UPDATE trade_head
INNER JOIN trade_taskitem_TNC202109130000079 AS b ON trade_head.id = b.trade_head_id 
SET trade_head.confirm_status = 0;