Objektová akce

Kód:

1

Tělo:

SELECT Car.RegPlate || ' (' || PL1.Name || '-' || PL2.Name || ') ' FROM MLBRepeatedRoutes A 
 LEFT JOIN TRMCars Car ON Car.ID = A.TRMCar_ID
 LEFT JOIN MLBRoutes RT ON RT.ID = A.MLBRoute_ID
 JOIN MLBPlaces PL1 ON PL1.ID = RT.StartPlace_ID
 JOIN MLBPlaces PL2 ON PL2.ID = RT.EndPlace_ID
WHERE A.ID = :OBJID

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