那位兄台看看问题出在哪呀?
ms sqlserver 2000 中提示 as有问题select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao as a LEFT OUTER JOIN
select * from ypjygl.bmcmxb as b
on a.ypjygl.ypmxb.bian_hao=b.ypjygl.bmcmxb.bian_hao
ms sqlserver 2000 中提示 as有问题select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao as a LEFT OUTER JOIN
select * from ypjygl.bmcmxb as b
on a.ypjygl.ypmxb.bian_hao=b.ypjygl.bmcmxb.bian_hao
(select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao) as a
LEFT OUTER JOIN
(select * from ypjygl.bmcmxb) as b
on a.ypjygl.ypmxb.bian_hao=b.ypjygl.bmcmxb.bian_hao
select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao a LEFT OUTER JOIN
select * from ypjygl.bmcmxb b
on a.ypjygl.ypmxb.bian_hao=b.ypjygl.bmcmxb.bian_hao又提示
服务器: 消息 170,级别 15,状态 1,行 6
第 6 行: 'a' 附近有语法错误。
服务器: 消息 156,级别 15,状态 1,行 8
在关键字 'on' 附近有语法错误。
(select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao) as a
LEFT OUTER JOIN
(select * from ypjygl.bmcmxb) as b
on a.bian_hao=b.bian_hao
(select kc.pi_haoyp,yp.bian_hao
from ypjygl.ypmxb yp,ypjygl.kcmxb kc
where yp_bz>=0 and yp.bian_hao=kc.bian_hao) as a
LEFT OUTER JOIN
(select * from ypjygl.bmcmxb) as b
on a.bian_hao=b.bian_hao