Třídová akce

Kód:

2

Tělo:

SELECT SUM(A.Amount) AS TotalExpenses, SUM(A.FuelQuantity) AS FuelQuantity, SUM(B.Amount) as TotalFuelPrice
FROM MLBExpenses A 
LEFT JOIN MLBExpenses B ON B.ID=A.ID AND B.MLBJourney_ID=:ID AND B.ExpenseType=0 
WHERE A.MLBJourney_ID=:ID

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