旧语法*=左连接=*右连接，转换成LEFT JOIN 显示失败，请高手帮助

[weixin_42082593]

SELECT COUNT(*)
FROM zybryzb,
sfxmdmb,
csdmb,
yfdmb,
dddmb,
czydmb,
ysdmb ,
pzspcjlb with(nolock)


WHERE pzspcjlb.zyh =* zybryzb.zyh and pzspcjlb.yzh =* zybryzb.yzh and

( zybryzb.xmdm = sfxmdmb.xmdm ) and

( zybryzb.csdm = csdmb.csdm ) and

( zybryzb.yfdm *= yfdmb.yfdm ) and

( zybryzb.dddm = dddmb.dddm ) and

( zybryzb.czydm *= czydmb.czydm) and

( zybryzb.ysgh *= ysdmb.ysgh) and

zybryzb.ysz_yzh >' ' and copy_nur >'' and isnull(exec_nur,'')='' and zybryzb.yfdm>'**'

/*将以上旧语法*=左连接，写成下面新语句*/


SELECT COUNT(*)

FROM pzspcjlb right join zybryzb on pzspcjlb.zyh = zybryzb.zyh ,
zybryzb left join yfdmb on zybryzb.yfdm = yfdmb.yfdm
left join czydmb on zybryzb.czydm = czydmb.czydm
left join ysdmb on zybryzb.ysgh = ysdmb.ysgh,
sfxmdmb,
csdmb,
dddmb
WHERE ( zybryzb.xmdm = sfxmdmb.xmdm ) and
( zybryzb.csdm = csdmb.csdm ) and ( zybryzb.dddm = dddmb.dddm ) and
zybryzb.ysz_yzh >' ' and copy_nur >'' and isnull(exec_nur,'')='' and zybryzb.yfdm>'**'

结果显示：
消息 1013，级别 16，状态 1，第 1 行
FROM 子句中的对象 "zybryzb" 和 "zybryzb" 具有相同的表现名称。请使用相关名称来区分它们。