按照子查询条件更新数据

需求介绍

客户有很多历史数据错误，需要修复

update bil_income a join  (SELECT
DISTINCT bil_income.bi_id
FROM
	`bil_income`
	LEFT JOIN `customer` ON customer.customer_code = bil_income.customer_code
	LEFT JOIN `bil_business` ON bil_business.bb_id = bil_income.bb_id
	LEFT JOIN `bil_business_attach` ON bil_business_attach.bb_id = bil_income.bb_id
	LEFT JOIN `bil_customer_bill` ON bil_customer_bill.bcb_id = bil_income.bcb_id
	LEFT JOIN `orders` ON orders.order_code = bil_business_attach.bb_refer_code 
WHERE
	( 1 = 1 ) 
	AND ( bi_amount > 0 ) 
	AND ( bil_business.bb_status = 'y' ) 
	AND ( bil_business.bb_confirm_sign = 'y' ) 
	AND ( bil_customer_bill.bcb_writeoff_sign = 'y' ) 
	AND ( bi_chargeable_time >= '2022-04-03 08:21:00' ) 
	AND ( bi_chargeable_time < '2022-04-03 08:22:00' ) 

	AND (
	is_waiting_payout = 1) )b on a.bi_id=b.bi_id set a.is_waiting_payout=0
	````