Třídová akce

Kód:

1

Tělo:

SELECT SUM(A.Amount) FROM NaturalWages A
 JOIN WagePeriods B ON A.ValidFrom_ID = B.ID
 LEFT JOIN WagePeriods C ON A.ValidTo_ID = C.ID
 WHERE A.Parent_ID = :Parent_ID
  AND B.DateFrom$DATE <= :DateTo
  AND (A.ValidTo_ID IS NULL OR C.DateTo$DATE >= :DateFrom)

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