Třídová akce

Kód:

5

Tělo:

SELECT {FIELDS}
 FROM WorkingRelations A
 LEFT OUTER JOIN Absences B ON
  (A.ID = B.WorkingRelation_ID AND
   B.AbsentFrom$DATE <= :DateTo AND ((B.AbsentTo$DATE = 0) OR (B.AbsentTo$DATE >= :DateFrom)) AND
   B.AbsenceBaseType = 5 AND B.{AbsFieldName} = 'A')
 WHERE A.Employee_ID = :EmployeeID AND A.{WRelFieldName} = 'A'
  AND A.DateOfBegin$DATE <= :DateTo
  AND ((A.DateOfEnd$DATE = 0) OR (A.DateOfEnd$DATE >= :DateFrom))
 ORDER BY B.WorkingRelation_ID, B.AbsentFrom$DATE

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