update 语句where 条件in是个select 子句的返回结果集的用法

UPDATE purchase_order_details e
SET del = '0' 
WHERE
 e.bom_head_code IN ( select * from (SELECT a.bom_head_code FROM purchase_order_details a, bom_head b WHERE a.bom_head_code = b.`code` AND b.sale_order_code = 'DL-GYL-QH-XS-202103-160005' ) cx)