SELECT A.ID CarID, MAX(B.BalanceDate$DATE) LastBalance FROM TRMCars A LEFT JOIN MLBBalances B ON B.TRMCar_ID = A.ID GROUP BY A.ID
Generated by ABRA Software a.s. 27.10.2021 16:35:26