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 總表)