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= 1时结果中

您可以使用CASE语句来实现对plan_status的赋值判断，当oaDelFlag=1时，将plan_status赋值为0。修改后的SQL语句如下：

SELECT plan.plan_id, plan.plan_name, oa.plan_status, CASE WHEN oa.del_flag = 1 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