Untitled
SELECT COUNT(*) FROM ( SELECT POP.PlantID, POP.ProjectID, POP.OEMID FROM tran_auditPlan AS TP INNER JOIN tran_auditProgram AS TAP ON TAP.AuditProgramID = TP.AuditProgramID RIGHT JOIN mst_mapping_plant_oem_project AS POP ON TAP.PlantID = POP.PlantID AND TAP.ProjectID = POP.ProjectID AND TAP.OEMID = POP.OEMID WHERE TAP.ConformityID = 1 AND TP.PlantID = 42 AND TP.FyID IN (CASE WHEN 4 <> 0 THEN 4 ELSE TP.FyID END) GROUP BY POP.PlantID, POP.ProjectID, POP.OEMID ) AS grouped_data;
Leave a Comment