SELECT {FIELDS} FROM WorkingRelations A
JOIN Employees B ON A.Employee_ID=B.ID
JOIN Persons C ON B.Person_ID=C.ID
JOIN EmployPatterns D ON A.EmployPattern_ID=D.ID
JOIN TypesOfBegin E ON E.ID = A.TypeOfBegin_ID
LEFT JOIN TypesOfEnd F ON F.ID = A.TypeOfEnd_ID
JOIN Divisions G ON G.ID = A.Division_ID
WHERE A.Hidden = 'N'Generated by ABRA Software a.s. 27.10.2021 16:34:36