Třídová akce

Kód:

11

Tělo:

SELECT {FIELDS}
 FROM Absences A
 JOIN WorkingRelations W ON W.ID = A.WorkingRelation_ID
 JOIN AbsenceTypes A2 ON A.ABSENCE_ID = A2.ID
 WHERE A.AbsentFrom$DATE <= :DateTo AND
  (A.AbsentTo$DATE = 0 OR A.AbsentTo$DATE >= :DateFrom) AND
  W.Employee_ID = :EmployeeID AND
  A2.CODE = :AbsenceCode

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