select (WP.Name || '-' || ST.Name) AS DisplayName from PLMWorkPlaceShiftTypes WPS left join PLMworkplaces WP on (WP.ID = WPS.Parent_ID) left join shifttypes ST on (ST.id = WPS.shifttype_id) where WPS.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:49