帮我把“SELECT ppo.supplier_id, ppo.supplier_name, count(distinct ppo.id) FROM pm_purchase_order ppo inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id -- and ppod.confirm_status = '1' and ppod.del_flag = '0' WHERE ppo.del_flag = '0' GROUP BY ppo.supplier_id, ppo.supplier_name”和“SELECT ppo.supplier_id, ppo.supplier_name, count(distinct ppo.id) FROM pm_purchase_order ppo inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id and ppod.confirm_status = '1' and ppod.del_flag = '0' WHERE ppo.del_flag = '0' GROUP BY ppo.supplier_id, ppo.supplier_name”合并成一个SQL语句

可以使用OR运算符将两个SELECT语句合并成一个，同时在第二个SELECT语句中添加一个条件判断，当ppod.confirm_status不等于1时，不计入结果。合并后的 SQL 语句如下：
SELECT ppo.supplier_id, ppo.supplier_name, count(distinct ppo.id)
FROM pm_purchase_order ppo
inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id
WHERE ppo.del_flag = '0' AND (ppod.confirm_status = '1' OR ppod.confirm_status <> '1' AND ppod.del_flag = '0')
GROUP BY ppo.supplier_id, ppo.supplier_name
登录后复制
注意，这个合并的语句中，ppod.del_flag = '0'条件是包含在括号里面的，因为它只对第二个SELECT语句生效。如果要对两个SELECT语句都生效，需要将这个条件移动到WHERE语句的外面，并使用AND运算符连接两个条件。