select (PS.Name || '-' || S.Name) AS DisplayName from posshops3 PS3 left join posshops PS on (PS.ID = PS3.Parent_ID) left join stores S on (S.id = PS3.store_id) where PS3.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:30