Как отобразить значение связаного поля в БД?
SELECT `a`.`id_car`, `m`.`MarkName`, `a`.`CarNumber`, `a`.`Fuel`, `a`.`isActive` 
    FROM `Автомобили` AS `a` 
        LEFT JOIN `Марки` AS `m` ON `a`.`MarkID` = `m`.`id_mark`
SELECT auto.id_car,
    auto.CarNumber,
    auto.Fuel,
    auto.isActive,
    (SELECT TOP(1) mark.MarkName
    FROM Марки as mark
    WHERE mark.MarkID = auto.id_mark)
FROM Автомобили as auto
ORDER BY auto.id_car