Třídová akce

Kód:

3

Tělo:

SELECT SUM(A.REALIZED) AS REALIZED, COUNT(A.ID) AS DOCKCOUNT,SUM(A.REQUIRED) AS REQUIRED,
 (SELECT MAX(WP2.ID) FROM WagePeriods WP2
  WHERE WP2.DateTo$DATE=(SELECT MAX(WP3.DateTo$DATE)
   FROM Docks DC, WagePeriods WP3
   WHERE DC.WagePeriod_ID=WP3.ID AND DC.DEFINITION_ID =:OBJID AND WP3.DATETO$DATE<:DATEFROM)) AS LASTPERIOD
 FROM Docks A JOIN WagePeriods WP ON A.WagePeriod_ID=WP.ID
 WHERE A.DEFINITION_ID = :OBJID AND WP.DATETO$DATE<:DATEFROM GROUP BY A.DEFINITION_ID

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