三表查询

select T.*,P.ProductName from 
(select V.CompanyID,C.CompanyName,V.ProductCode 
from VehicleInsuranceAgentConfiguration V
inner join Company C
on V.CompanyID = C.CompanyID
where V.IsDelete=0 and V.Host<>'' and V.XmlConfig<>'') T 
inner join Product P
on T.ProductCode = P.ProductCode