Use the select clause from the first recordset:
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
and the where clause from the second recordset:
WHERE vehicle.VehicleCotw = 1
ORDER BY vehicle.VehicletUpdateDate ASC LIMIT 1
so the entire recordset is:
SELECT Vehicle.*, manufacturer.VehicleManufacturerName
FROM Vehicle INNER JOIN manufacturer ON Vehicle.VehicleManufacturerID = manufacturer.VehicleManufacturerID
WHERE vehicle.VehicleCotw = 1
ORDER BY vehicle.VehicletUpdateDate ASC LIMIT 1