Objektová akce

Kód:

2

Tělo:

SELECT Car.RegPlate || ' ' || CAST(A.RouteDateFrom$DATE AS VARCHAR(30)) || ' (' || PL1.Name || '-' || PL2.Name || ') ' FROM MLBJourneys A 
 LEFT JOIN TRMCars Car ON Car.ID = A.TRMCar_ID
 JOIN MLBPlaces PL1 ON PL1.ID = A.StartPlace_ID
 JOIN MLBPlaces PL2 ON PL2.ID = A.EndPlace_ID
WHERE A.ID = :OBJID

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