update car c,car_series cs,car_brand cb,brand b set c.brand_name=b.b_name where c.cs_id=cs.cs_id and cs.cb_id = cb.cb_id and cb.b_id = b.b_id;