sqlserve 中的sql语句在sybase中无法用，如何转换？

gongyifeng_cs

sql语句如下：
select netnodeno,
(select count(phoneid) from netnodeinfo_pid where netnodeno=tp.netnodeno) as pidcount,
(select count(merchno)  from netnodeinfo_pos where netnodeno=tp.netnodeno) as merchcount,
(select count(date) from netnodeinfo_jrn where netnodeno=tp.netnodeno) as jrncount,
(select sum(CAST(amt AS float(16))) from netnodeinfo_jrn where netnodeno=tp.netnodeno) as atmcount,
(select sum(CAST(kickback AS float(16))) from netnodeinfo_jrn where netnodeno=tp.netnodeno) as kickbackcount
from
(
    select netnodeno from netnodeinfo_pid group by netnodeno union
    select netnodeno from netnodeinfo_pos group by netnodeno union
    select netnodeno from netnodeinfo_jrn group by netnodeno
)tp
where netnodeno=''

sybase中无法用
谢谢
好像是tp好像无法识别？？？

szbjshhnsd

Sybase目前不支持把查询结果集做为表名的，把以上语句使用标准语句分解吧

gongyifeng_cs

怎么分解呀？？？
我试过用
发表于: 2006-10-11 15:17      [编辑]  [引用]  [投诉] [快速回复]  


--------------------------------------------------------------------------------

sql语句如下：
select tp.netnodeno

from
(
    select netnodeno from netnodeinfo_pid group by netnodeno union
    select netnodeno from netnodeinfo_pos group by netnodeno union
    select netnodeno from netnodeinfo_jrn group by netnodeno
)tp
是可以的，然后加上去就出现5条错误，说是无效的列名