left join 多次同一个表出现重复数据

[zhang20087701]

select a.vBCID,a.vIDNumber,a.nPopulationType,
a.nResidentialType,b.vsyscodename nresidentialtypename,a.vJB_XM,a.vJB_XB,a.vJB_MZ,c.vsyscodename vjb_mzname,a.vJB_CSRQ,
a.vJB_WHCD,d.vsyscodename vjb_whcdname,a.nJB_HYZK,e.vsyscodename njb_hyzkname,a.nJB_HYFWLX,a.vJB_CHRQ,a.vJB_JHRQ,
a.vJB_HKXZ,f.vsyscodename vjb_hkxzname,a.vJB_ZCLX,g.vsyscodename vjb_zclxname,a.vJB_LRGLHTH,a.vJB_HTRQ,a.vJB_LXFS,
a.vJB_HYFZRQ,a.vJB_HYZMH,a.vJB_HYZMLX,a.vJB_YXQ,a.vJB_LRRQ,
a.vJB_JSBDH,a.vJB_LRD,a.vJB_LRDDW,a.vJB_LRDXXDZ,a.vJB_LCD,
a.vPO_XM,a.vPO_CSRQ,a.vPO_SFZ,a.vPO_HYZK,h.vsyscodename vpo_hyzkname,a.vPO_LXFS,a.vPO_HJD,
a.vSYZ_XH,a.vSYZ_FZDW,a.vSYZ_FZRQ,a.vSYZ_ZFRQ,a.vSYZ_ZFYY,i.vsyscodename vsyz_zfyyname,
a.vJY_SSM,j.vsyscodename vjy_ssmname,a.vJY_SSRQ,a.vJY_SSDW,a.vJY_WCYY,k.vsyscodename vjy_wcyyname,a.vJY_BYZZRQ,
a.vJY_BYZZJG,a.vJY_SSYS,a.vKJ_DH,a.vKJ_DW,a.vKJ_JG,a.vKJ_YS,
a.vRS_MCYJ,a.vRS_HYZC,a.vRS_ZZDD,a.vRS_ZZRQ,a.vRS_JG,a.vRS_ZZYY,l.vsyscodename vrs_zzyyname,
a.vFY_ZSRQ,a.vFY_ZSYY,m.vsyscodename vfy_zxyyname,a.vFY_ZSDW,a.vFY_YHJE,a.vFY_YZJE,a.vFY_ZSLS,
a.nDeletationStateCode,a.nZN_NanHS,a.nZN_NuHS,a.nZN_ZCN,a.nZN_ZCW,
a.vPO_CHRQ,a.vPO_JHRQ,a.vPO_CYDZ,a.vDSZNGR_ZH,a.vDSZNGR_LZRQ,
a.vDSZNGR_FZDW,a.vDSZNGR_ZFRQ,a.vDSZNGR_ZFYY,n.vsyscodename vdszngr_zfyyname,a.vDSZNGR_ZCLX,o.vsyscodename vdszngr_zclxname,
a.vJB_HJD,a.nNL,vCYD,a.vLX_GZDW,a.vLX_GDDH,a.vLX_SJ,a.vLX_QQ,
vLX_DZXX,vCreateOn,vCreateBy,vModifyBy,vModifyOn,
a.VCODE,a.vCategoryId,a.vHousingId,a.vNetworkID,a.vJB_CYSJ,
nHouseholder,vJYZK,p.vsyscodename vjyzkname,vJYXZ,q.vsyscodename vjyxzname from BirthControlBase a
left join syscodebase b on a.nresidentialtype=b.vsyscode
left join syscodebase c on a.vjb_mz=c.vsyscode
left join syscodebase d on a.vjb_whcd=d.vsyscode
left join syscodebase e on a.njb_hyzk=e.vsyscode
left join syscodebase f on a.vjb_hkxz=f.vsyscode
left join syscodebase g on a.vjb_zclx=g.vsyscode
left join syscodebase h on a.vpo_hyzk=h.vsyscode
left join syscodebase i on a.vsyz_zfyy=i.vsyscode
left join syscodebase j on a.vjy_ssm=j.vsyscode
left join syscodebase k on a.vjy_wcyy=k.vsyscode
left join syscodebase l on a.vrs_zzyy=l.vsyscode
left join syscodebase m on a.vfy_zsyy=m.vsyscode
left join syscodebase n on a.vdszngr_zfyy=n.vsyscode
left join syscodebase o on a.vdszngr_zclx=o.vsyscode
left join syscodebase p on a.vjyzk=p.vsyscode
left join syscodebase q on a.vjyxz=q.vsyscode

[--小F--]

是哪些数据重复?

[jxqn_liu]

这个啥表，一个表的字段关联另一个表的多个字段

[chuanzhang5687]

费解中

[cd731107]

关联的字段出现了一对多的关系，
比如：from BirthControlBase a
left join syscodebase b on a.nresidentialtype=b.vsyscode
其中可能
BirthControlBase的一个nresidentialtype对应syscodebase的多个vsyscode
其他类似

[艾米01]

楼主发帖了，就不来看看了。

[勿勿]

join前看下是不是有一对多的情况！