
SQLquery=SELECT ' '+ ' '+dbo.VehicleName.VehicleName+' intro:'+dbo.VehicleName.ModelYear +' ' as link FROM (((dbo.Specification INNER JOIN dbo.VehicleName ON dbo.Specification.VehicleID = dbo.VehicleName.VehicleID) INNER JOIN dbo.MarketGroup ON dbo.Specification.MarketGroupID = dbo.MarketGroup.ID) INNER JOIN dbo.MarketOrder ON dbo.MarketGroup.MarketOrderID = dbo.MarketOrder.ID)
WHERE ((( dbo.VehicleName.VehicleName) Like 'Lotus%') AND ((dbo.Specification.ValidSpec)=1) AND ((dbo.MarketOrder.OrderTypeID)=2)) ORDER BY dbo.VehicleName.VehicleName;
|