SELECT WR.ID FROM WorkingRelations WR
JOIN Employees EMP ON WR.Employee_ID=EMP.ID
WHERE
(WR.DateOfBegin$DATE <= :VALIDTO) AND
(WR.DateOfEnd$Date = 0 OR WR.DateOfEnd$DATE >= :VALIDFROM) AND
({Condition}) Generated by ABRA Software a.s. 27.10.2021 16:34:36