Třídová akce

Kód:

9

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) or ('0000000000' = :WorkingRelationID)) AND
  A.AbsenceBaseType IN ({BaseTypes})

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