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)
update 语句where 条件in是个select 子句的返回结果集的用法
最新推荐文章于 2024-06-10 08:07:38 发布