SELECT b.Code FROM WorkingRelations A JOIN Divisions B ON A.DIVISION_ID = B.ID WHERE A.Hidden<>'A' and A.Employee_ID=:OBJID and ((A.DateOfEnd$Date = 0) OR (A.DateOfEnd$DATE >= :DATEFROM)) and ((:DATETO=0) OR (A.DateOfBegin$Date <=:DATETO)) GROUP BY b.code
Generated by ABRA Software a.s. 27.10.2021 16:34:35