with res as (select top(20) DiDealerInventory.DealerCode dcode,CarSeries,Vin,MdmDealer.SystemCode sysd
from DiDealerInventory
LEFT JOIN MdmDealer ON MdmDealer.DealerCode=DiDealerInventory.DealerCode
where CarSeries='SUV-CN210S'),
res2 as (select DealerCode dcode
from MdmDealer,res where SystemCode=res.sysd)
select res.CarSeries,res.Vin,res.sysd,res.dcode,
VehDealerWareHouse.Name,VehDealerWareHouse.Location,VehDealerWareHouse.WareHousePoint
from VehDealerWareHouse,res2,res where VehDealerWareHouse.DealerCode=res2.dcode