SELECT planplan_id planplan_name oaplan_status oadel_flag oaDelFlagFROM cm_maintenance_plan AS plan LEFT JOIN pigxx_acoa_plan_examine AS oa ON planplan_id = oaplan_id 现在需要在sql语句里判断一下当oaDelFlag= 0时结果中

您可以使用CASE语句在SQL查询中进行条件判断和值替换来实现您的需求。下面是修改后的SQL语句：

SELECT plan.plan_id, plan.plan_name, oa.plan_status, CASE oa.del_flag WHEN 0 THEN 0 ELSE oa.del_flag END AS oaDelFlag FROM cm_maintenance_plan AS plan LEFT JOIN pigxx_ac.oa_plan_examine AS oa ON plan.plan_id = oa.plan_id