Třídová akce

Kód:

8

Tělo:

SELECT {FIELDS}
 FROM Absences A
 JOIN WorkingRelations W ON W.ID = A.WorkingRelation_ID
 WHERE A.AbsentFrom$DATE <= :DateTo AND
  (A.AbsentTo$DATE = 0 OR A.AbsentTo$DATE >= :DateFrom) AND
  A.WorkingRelation_ID = :WorkingRelationID AND
  A.AbsenceBaseType = 5 AND
  A.ExTimeType IN ({ExTimeTypes})

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