If I'm understanding your question, then you may just need to add a GROUP BY and then use the MAX function to get one of the image fields.
SELECT dbo.Tbl_Car_detail.CarID, dbo.tbl_mst_CarDetail.CarBrand, MAX(tbl_car_Image.Image)
FROM dbo.Tbl_Car_detail
RIGHT OUTER JOIN tbl_car_Image.Image
ON dbo.Tbl_Car_detail.CarID = dbo.tbl_car_Image.CarID
GROUP BY dbo.Tbl_Car_detail.CarID, dbo.tbl_mst_CarDetail.CarBrand
Or if you need to ensure that you're getting the top image for each group (order matters), then perhaps you can use a common table expression like this:
WITH cte AS
(
SELECT dbo.Tbl_Car_detail.CarID,
dbo.tbl_mst_CarDetail.CarBrand,
tbl_car_Image.Image,
ROW_NUMBER() OVER (PARTITION BY dbo.Tbl_Car_detail.CarID, dbo.tbl_mst_CarDetail.CarBrand ORDER BY tbl_car_Image.Image DESC) AS rownum
FROM dbo.Tbl_Car_detail
RIGHT OUTER JOIN tbl_car_Image.Image
ON dbo.Tbl_Car_detail.CarID = dbo.tbl_car_Image.CarID
)
SELECT CarID, CarBrand, Image
FROM cte
WHERE rownum = 1
I'll admit to not actually creating tables and running either of these queries, so you may need to tweak them before use.