Třídová akce

Kód:

11

Tělo:

SELECT SUM({FieldName})
 FROM WageListPartial A JOIN WagePeriods B ON A.WagePeriod_ID = B.ID
 WHERE A.WorkingRelation_ID = :WrkRelationID 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