from GH_GHZDK a (nolock), YY_YBFLK b (nolock), SF_BRXXK c (nolock),YY_ZYDMK d (nolock),YY_BRDYLYK e (nolock),
(select g.ghxh,g.ylxm as 'ylxmdm',h.name as 'ylxmmc',m.zddm as 'dbzddm',m.zdmc as 'dbzdmc' from SF_BRJSK g (nolock),YY_YLXMK h(nolock),YB_DBZDDMK m(nolock) where rtrim(g.ylxm)<>'' and g.ghsfbz=0 and rtrim(g.ylxm)=rtrim(h.id) and rtrim(g.zddm)*=rtrim(m.zddm) ) p
where xh = @ghxh and a.ybdm = b.ybdm and a.patid = c.patid and c.zydm*=d.id and c.dyid*=e.id and xh*=p.ghxh 求助把上面语句改成 join 形式。被连接嵌套搞晕了,此脚本在2005上能运行,在SQL2000就报错。
(select g.ghxh,g.ylxm as 'ylxmdm',h.name as 'ylxmmc',m.zddm as 'dbzddm',m.zdmc as 'dbzdmc' from SF_BRJSK g (nolock),YY_YLXMK h(nolock),YB_DBZDDMK m(nolock) where rtrim(g.ylxm)<>'' and g.ghsfbz=0 and rtrim(g.ylxm)=rtrim(h.id) and rtrim(g.zddm)*=rtrim(m.zddm) ) p
where xh = @ghxh and a.ybdm = b.ybdm and a.patid = c.patid and c.zydm*=d.id and c.dyid*=e.id and xh*=p.ghxh 求助把上面语句改成 join 形式。被连接嵌套搞晕了,此脚本在2005上能运行,在SQL2000就报错。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货