Question

access sql 转MSSQL遇到的问题

SELECT id, (select sum(czmoney) from sh_chongzhi where id=1) AS sumcz, (sumcz-1) AS leftye FROM huiyuan where username='"&username&"'
提示列名 sumcz 无效
但这句话在ACCESS 时执行正常
注sumcz列不存在！在SQL中热行了前面的select后，查询结果就会出现!求高手解决！

Answer 1

你可以再多用一个SELECT，把先查到结果当成一个记录集来进行处理。
如：

select id,sumcz, (sumcz-1) AS leftye
(
SELECT id, (select sum(czmoney) from sh_chongzhi where id=1) AS sumcz, FROM huiyuan where username='"&username&"'
)