通过数据库查询语句,
1、先在故障表中找出发生故障A的车辆故障视图view
2、然后再找出发生故障B的车辆故障视图view
3、将这个两个view进行合并找出相同的车辆号
sql语句:
select aa.car_Id from
(select car_Id from carInfo where car_Error=A) AS aa
union
(select car_Id from carInfo where car_Error=B) AS bb
where aa.car_Id=bb.car_Id;