Třídová akce

Kód:

1

Tělo:

SELECT A.ID
FROM SickBenefits2 A
JOIN SickBenefits SB ON A.Parent_ID = SB.ID
WHERE (SB.WorkingRelation_ID = :WR) and
      (SB.ID <> :SBID) and
      (
      ((A.AbsentFrom$DATE <= :ABSENTTO) and (A.AbsentFrom$DATE >= :ABSENTFROM))
      or
      ((A.AbsentTo$DATE <= :ABSENTTO) and (A.AbsentTo$DATE >= :ABSENTFROM))
      )

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