delete删除select查询出来的结果

UPDATE stock_in_record_detail 
SET delete_flag = 1 
WHERE
	id IN (
	SELECT
		* 
	FROM
		(
		SELECT
			d.id
		FROM
			stock_in_record_detail d
			LEFT JOIN stock_in_record r ON d.stock_in_record_id = r.id 
			AND r.delete_flag = 0
			LEFT JOIN transit_main m ON r.deliver_code = m.transit_code 
			AND m.delete_flag = 0 
		WHERE
			d.delete_flag = 0 
			AND d.storage_code = 'F01' 
			AND r.order_type IS NULL 
		ORDER BY
			r.createdate DESC 
		) AS c 
	)