So, I guess the below subquery is the problem.
select Vehicle_Id from [dbo_pibm].[tbl_Vehicle_Journey] group by Vehicle_Id HAVING MAX(Id)>0
Run this independently and see how many results are coming. If more than one are coming, then this is the issue. Make it correct to return one value only.