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