Třídová akce

Kód:

8

Tělo:

SELECT SUM({FieldName})
FROM WageListCommon A 
JOIN WagePeriods B ON A.WagePeriod_ID = B.ID
WHERE 
  A.Employee_ID = :EmployeeID AND
  {WPeriodFunction}(B.{WPeriodFieldName}) =
   (SELECT {WPeriodFunction}({WPeriodFieldName})
    FROM WagePeriods
    WHERE ID = :WPeriodID) AND
  B.DateFrom$DATE {RelationalOperator}
   (SELECT DateFrom$DATE
    FROM WagePeriods
    WHERE ID = :WPeriodID)

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