高手们请你们帮忙___

[yangkezhu]

SELECT KY_BRRY.ZYHM,
KY_BRRY.BRXZ,
KY_BRRY.BRXM,
KY_BRRY.BRXB,
KY_BRRY.SFZH,
KY_BRRY.GZDW,
KY_BRRY.RYRQ,
KY_BRRY.RYQK,
KY_BRRY.BRCH,
YS_ZY_BRRY.STJC,
YS_ZY_BRRY.ZYH,
KY_RYZD.ZDXH,
KY_RYZD.ZDLB,
KY_RYZD.ZGQK,
KY_BRRY.QZRQ,
KY_BRRY.ZYYS,
KY_BRRY.ZSYS,
KY_BRRY.ZZYS,
KY_BRRY.YSDM
FROM KY_BRRY LEFT OUTER JOIN YS_ZY_BRRY ON KY_BRRY.ZYH = YS_ZY_BRRY.ZYH, ZY_RYZD RIGHT OUTER JOIN KY_BRRY ON ZY_RYZD.ZYH = KY_BRRY.ZYH
WHERE KY_BRRY.ZYH = 47
在查询分析器中提示错误为：表或函数 'KY_BRRY' 和 'KY_BRRY' 具有相同的表现名称。请用相关名称区分它们

请高手们帮忙，多谢！！

[mgsray]

SELECT KY_BRRY.ZYHM,
KY_BRRY.BRXZ,
KY_BRRY.BRXM,
KY_BRRY.BRXB,
KY_BRRY.SFZH,
KY_BRRY.GZDW,
KY_BRRY.RYRQ,
KY_BRRY.RYQK,
KY_BRRY.BRCH,
YS_ZY_BRRY.STJC,
YS_ZY_BRRY.ZYH,
KY_RYZD.ZDXH,
KY_RYZD.ZDLB,
KY_RYZD.ZGQK,
KY_BRRY.QZRQ,
KY_BRRY.ZYYS,
KY_BRRY.ZSYS,
KY_BRRY.ZZYS,
KY_BRRY.YSDM
FROM KY_BRRY LEFT OUTER JOIN YS_ZY_BRRY ON KY_BRRY.ZYH = YS_ZY_BRRY.ZYH
left outer join ZY_RYZD ON ZY_RYZD.ZYH = KY_BRRY.ZYH
WHERE KY_BRRY.ZYH = 47

[yangkezhu]

拿你的运行，还是提示和我那个一样的错误

[yangkezhu]

哦，不对，可以运行，我还没有仔细看结果对不对，先谢谢

[playyuer]

alias:
SELECT KY_BRRY.ZYHM,
KY_BRRY.BRXZ,
KY_BRRY.BRXM,
KY_BRRY.BRXB,
KY_BRRY.SFZH,
KY_BRRY.GZDW,
KY_BRRY.RYRQ,
KY_BRRY.RYQK,
KY_BRRY.BRCH,
YS_ZY_BRRY.STJC,
YS_ZY_BRRY.ZYH,
KY_RYZD.ZDXH,
KY_RYZD.ZDLB,
KY_RYZD.ZGQK,
KY_BRRY.QZRQ,
KY_BRRY.ZYYS,
KY_BRRY.ZSYS,
KY_BRRY.ZZYS,
KY_BRRY.YSDM
FROM
KY_BRRY LEFT OUTER JOIN YS_ZY_BRRY ON KY_BRRY.ZYH = YS_ZY_BRRY.ZYH, ZY_RYZD RIGHT OUTER JOIN KY_BRRY as a ON ZY_RYZD.ZYH = a.ZYH