Třídová akce

Kód:

5

Tělo:

SELECT SUM(Un.Sm), MAX(Un.Dt)
FROM
  (
   SELECT SUM(C.RealWorkPrice + C.RealMaterialPrice) AS Sm, MAX(C.DOCDATE$DATE) AS Dt 
     FROM PLMCOOPERATIONS C WHERE C.JobOrder_ID = :JO_ID
   UNION ALL
   SELECT 0 AS Sm, MAX(C.CORRECTEDAT$DATE) AS Dt 
     FROM PLMCOOPERATIONS C WHERE C.JobOrder_ID = :JO_ID
   UNION ALL
   SELECT 0 AS Sm, MAX(C.TAKENOFFAT$DATE) AS Dt 
     FROM PLMCOOPERATIONS C WHERE C.JobOrder_ID = :JO_ID
   UNION ALL
   SELECT 0 AS Sm, MAX(C.RETURNEDAT$DATE) AS Dt 
     FROM PLMCOOPERATIONS C WHERE C.JobOrder_ID = :JO_ID
   UNION ALL
   SELECT 0 AS Sm, MAX(C.ACCDATE$DATE) AS Dt 
     FROM PLMCOOPERATIONS C WHERE C.JobOrder_ID = :JO_ID
  ) Un

Generated by ABRA Software a.s. 27.10.2021 16:34:49