select * from 综合 where CarNO in (select CarNO from 总表)
select * from 上海 where CarNO in (select CarNO from 总表)
select * from 一汽 where CarNO in (select CarNO from 总表)
select 连锁.*,总表.ZBStoreName from 连锁,总表 where 连锁.CarNO =总表.CarNO and 连锁.ClintName=总表.ClintName order by 连锁.LSStoreName,总表.ZBStoreName
select * from 维修 where CarNO in (select CarNO from 总表)