Objektová akce

Kód:

4

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=:OBJID AND B.ExpenseType=0 
WHERE A.MLBJourney_ID=:OBJID

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