22,207
社区成员
发帖
与我相关
我的任务
分享
select count(distinct(DI.LoginName)) as DealerCount
from AC_DealerBaseInfo as DI,AC_DealerSeries as DS,[360che]..[AC_CarModel_Series] as CS,[Franchiser]..[AC_ChinaCityRelation] as CC
where
DI.LoginName=DS.LoginName
and
DS.CarSeriesId=CS.SeriesId
and
DI.CityId=CC.F_Id
and CC.F_ProvinceId=@F_ProvinceId
and CS.BrandId=@BrandId
and DI.IsCharge=@IsCharge
and DI.IsEnable=@IsEnable
select count(distinct(DI.LoginName)) as DealerCount
from AC_DealerBaseInfo as DI,AC_DealerSeries as DS,[360che]..[AC_CarModel_Series] as CS,[Franchiser]..[AC_ChinaCityRelation] as CC
where DI.LoginName=DS.LoginName
and DS.CarSeriesId=CS.SeriesId
and DI.CityId=CC.F_Id
and CC.F_ProvinceId=@F_ProvinceId
and BrandId=@BrandId
select count(distinct(BP.LoginName)) as AllPass from [360Franchiser]..[AC_DealerBaseInfo] as BI,AC_DealerSeries as DS,[360che]..[AC_CarModel_Series] as CS, [360Franchiser]..[AC_CheckExtendDealerBaseInfoPic] as BP,[Franchiser]..[AC_ChinaCityRelation] as CC
where BI.LoginName=BP.LoginName and BI.CityId=CC.F_Id and BI.LoginName=DS.LoginName and DS.CarSeriesId=CS.SeriesId
and OperateType='Pass' and BI.LoginName not in(select LoginName from [360Franchiser]..[AC_CheckExtendDealerBaseInfoPic] where OperateType <> 'Pass' or isnull(OperateType,'')='')
and CC.F_ProvinceId=@F_ProvinceId and CS.BrandId=@BrandId and BI.IsCharge=@IsCharge and BI.IsEnable=@IsEnable
select * from tbA as a inner hash join tbB as b on a.字段=b.字段
个人建议,仅供参考。