Column 'id' in field list is ambiguous

• 原因：sql语句进行多表联查，但是每张表主键都为id，所以id出现二义性

• 解决方法：修改xml文件中的方法，将原语句中的*变为所有字段名

<select id="findAllCar" resultMap="carMap">
select
      car.id, car_no, car_brand, car_model, car_color, car_load, car_seats, oil_wear, init_mil,
      maintain_mil, maintain_period, engine_num, frame_num, sup_id, purchase_price, purchase_date,
      dept_id, car_state, remarks, isdisable, car_brand.id, pid, brand_name
from 
      car,car_brand 
where 
      car.car_brand = car_brand.id
</select>