select (PS.Name || '-' || SC.Name) AS DisplayName from posshops7 PS7 left join posshops PS on (PS.ID = PS7.Parent_ID) left join shiftcalendar SC on (SC.id = PS7.shiftcalendar_id) where PS7.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:30