Objektová akce

Kód:

2

Tělo:

SELECT SP.Name || '-' || EP.Name
 || COALESCE(', ' || F.Name || COALESCE(' (' || FO.Name || ')', ''), '')
 FROM MLBRoutes A
 LEFT JOIN MLBPlaces SP ON SP.ID = A.StartPlace_ID
 LEFT JOIN MLBPlaces EP ON EP.ID = A.EndPlace_ID
 LEFT JOIN Firms F ON F.ID = A.Firm_ID
 LEFT JOIN FirmOffices FO ON FO.ID = A.FirmOffice_ID
WHERE A.ID=:OBJID

Generated by ABRA Software a.s. 27.10.2021 16:35:26