select (PS.Name || '-' || C.Name) AS DisplayName from posshops4 PS4 left join posshops PS on (PS.ID = PS4.Parent_ID) left join currencies C on (C.id = PS4.currency_id) where PS4.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:30