Třídová akce

Kód:

10

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
  W.Employee_ID = :EmployeeID AND
  A.AbsenceBaseType IN ({BaseTypes})

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