Untitled

 avatar
unknown
plain_text
a month ago
553 B
2
Indexable
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